Results for “so_report_printers”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The OE.SO_REPORT_PRINTERS table is an Order Entry configuration table that stores report printer assignments. It defines which Oracle Reports output destination (printer) is used for a given Order Management report, scoped by a configurable level such as organization, user, or responsibility. Rather than relying on a single global printer for every Order Entry report, the table allows administrators to route each report to an appropriate device depending on the operating context in which the report is submitted.

The table is owned by the OE (Order Entry) schema and is documented as VALID in the ETRM 12.2.2 physical schema, containing 12 columns. From a Data Vault modeling perspective, the metadata’s heuristic classification is link. This suggests modeling SO_REPORT_PRINTERS as a link table that resolves the relationships between a report definition (SO_REPORTS) and a printer definition (FND_PRINTER), with the level identifiers acting as additional qualifying keys.

Key Information Stored

The primary key of the table is SO_REPORT_PRINTERS_PK, composed of REPORT_ID, LEVEL_TYPE_ID, and LEVEL_VALUE_ID. A unique index, SO_REPORT_PRINTERS_U1, exists on the same three columns, functioning as the business-key candidate. These three columns together determine both the report being configured and the context level to which the printer assignment applies.

• REPORT_ID — Identifies the Order Entry report whose output destination is being configured; joins to SO_REPORTS.
• LEVEL_TYPE_ID — Identifies the type of assignment level (for example, organization or another configurable scope) that qualifies the assignment.
• LEVEL_VALUE_ID — Identifies the specific value for the level type, narrowing the assignment to a particular context.
• PRINTER_NAME — The name of the printer to which the report is routed; joins to FND_PRINTER.
• ENABLE_FLAG — Indicates whether the printer assignment is active and should be honored at runtime.
• DESCRIPTION — Free-text description of the assignment for administrative reference.
• APPLICATION_ID — Identifies the application context associated with the assignment.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle Applications audit (WHO) columns recording row creation and modification history.

Common Use Cases and Queries

Typical uses center on verifying and reporting printer routing per report and level. A common query joins the table to SO_REPORTS and FND_PRINTER to resolve both the report name and printer description:

• Listing all active printer assignments: SELECT REPORT_ID, LEVEL_TYPE_ID, LEVEL_VALUE_ID, PRINTER_NAME FROM OE.SO_REPORT_PRINTERS WHERE ENABLE_FLAG = 'Y';
• Resolving report and printer names: join SO_REPORT_PRINTERS to SO_REPORTS on REPORT_ID and to FND_PRINTER on PRINTER_NAME.
• Troubleshooting why a report prints to an unexpected device by filtering on a specific REPORT_ID and LEVEL_VALUE_ID.
• Auditing configuration changes using CREATED_BY, LAST_UPDATED_BY, and LAST_UPDATE_DATE.

Related Objects

• SO_REPORTS — referenced via SO_REPORT_PRINTERS.REPORT_ID; defines the report being configured.
• FND_PRINTER — referenced via SO_REPORT_PRINTERS.PRINTER_NAME; defines the printer device.
• SO_REPORT_PRINTERS_PK / SO_REPORT_PRINTERS_U1 — primary key and unique index enforcing the report/level uniqueness.
• OE Order Management report submission and concurrent program components — consume these assignments when determining print destinations at runtime.