Results for “so_report_printers_qf_v”

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

Overview

SO_REPORT_PRINTERS_QF_V is a view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Oracle Order Entry (OE) product family and is documented in the ETRM repository with the abbreviated description "10SC Only," indicating it is a specialized query component built for a particular Order Entry reporting or printer-assignment flow rather than a general-purpose dictionary object. The view joins the SO_REPORT_PRINTERS configuration table with printer, user, responsibility, application, profile option, and concurrent program definitions, resolving each printer assignment to a human-readable level name. Its role is to expose the relationship between concurrently generated Order Entry reports and the printers assigned at various security levels — site, application, responsibility, or user — so that report output is routed to the correct physical device according to FND profile and security configuration. Because it resolves foreign keys to descriptive name columns via outer joins, it is primarily consumed by Oracle Forms and concurrent program logic rather than by end-user ad hoc reporting, and it should be treated as an internal, Oracle-managed object rather than a supported integration point.

Underlying Base Objects

The view is defined over eight referenced objects: FND_PRINTER_TL, FND_USER, FND_RESPONSIBILITY_TL, FND_CONCURRENT_PROGRAMS_VL, FND_APPLICATION_TL, FND_PROFILE_OPTION_VALUES, SO_REPORTS, and SO_REPORT_PRINTERS. SO_REPORT_PRINTERS is the driving table, supplying report-to-printer assignments together with the level type and level value identifiers. SO_REPORTS provides the report definition that is matched by name to FND_CONCURRENT_PROGRAMS_VL, linking the custom Order Entry report registry to the concurrent program that actually executes. FND_PRINTER_TL supplies the translated PRINTER_NAME used as the join key. The remaining objects are joined with outer joins keyed on LEVEL_VALUE_ID, so that a row is returned whether the assignment level refers to an application (FND_APPLICATION_TL), a responsibility (FND_RESPONSIBILITY_TL), a user (FND_USER), or a profile option value (FND_PROFILE_OPTION_VALUES, restricted to PROFILE_OPTION_ID = 125). All base objects are referenced through APPS synonyms, and no object other than the view itself is owned by the OE schema.

Key Columns

• ROW_ID — the ROWID of the underlying SO_REPORT_PRINTERS row, used by Oracle Forms for optimistic locking.
• REPORT_ID — identifies the Order Entry report definition in SO_REPORTS to which the printer assignment applies.
• REPORT_NAME — the concurrent program user name from FND_CONCURRENT_PROGRAMS_VL, providing the display name of the report.
• LEVEL_TYPE_ID — numeric discriminator for the assignment level: 10001 for profile option, 10002 for application, 10003 for responsibility, and 10004 for user.
• LEVEL_VALUE_ID — the identifier of the specific level instance; interpreted according to LEVEL_TYPE_ID.
• LEVEL_NAME — a DECODE-derived descriptive label: the profile option value, application name, responsibility name, or user name corresponding to the row.
• PRINTER_NAME — the printer to which the report is routed, drawn from FND_PRINTER_TL.
• ENABLE_FLAG and DESCRIPTION — the active status and free-text description of the assignment.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns propagated from SO_REPORT_PRINTERS.

Common Use Cases and Queries

Typical usage is diagnostic: confirming which printer an Order Entry report will be routed to for a given responsibility or user, or listing all enabled assignments. Because LEVEL_NAME is resolved through DECODE on LEVEL_TYPE_ID, a query can filter by level type without joining the security tables again.

SELECT report_name,
       level_type_id,
       level_name,
       printer_name,
       enable_flag
FROM   apps.so_report_printers_qf_v
WHERE  enable_flag = 'Y'
AND    level_type_id = 10003
ORDER  BY report_name, level_name;

The view can also be queried to audit assignments for one report or to verify the printer configured for a specific user:

SELECT report_name, level_name, printer_name
FROM   apps.so_report_printers_qf_v
WHERE  report_id = :p_report_id;

SELECT report_name, printer_name
FROM   apps.so_report_printers_qf_v
WHERE  level_type_id = 10004
AND    level_name = :p_user_name;

Given the "10SC Only" designation and its dependency on profile option 125, the view should be treated as internal Oracle functionality. Custom code should avoid direct DML against SO_REPORT_PRINTERS and instead maintain assignments through the supported Order Entry printer setup forms.