Search Results report_application_id

Overview

The SO_REPORTS table is a core repository within the Oracle E-Business Suite (EBS) Order Entry/Shipping (OE) module, specifically for versions 12.1.1 and 12.2.2. It serves as a master registry for all concurrent reports and programs associated with order processing. Its primary role is to define and manage the executable reports that can be submitted from the Order Management forms, such as Pick Slips, Packing Slips, Invoices, and Order Acknowledgements. The table establishes the critical link between the Order Management application's user interface and the underlying Concurrent Manager processing framework, enabling the submission, parameter passing, and execution of shipping and billing documents.

Key Information Stored

The table's structure is designed to uniquely identify and configure each report. The primary key, REPORT_ID, is a unique numeric identifier for each report record. The table enforces uniqueness through a composite unique key (SO_REPORTS_UK1) on the combination of REPORT_APPLICATION_ID and NAME. The REPORT_APPLICATION_ID column stores the application identifier (e.g., from FND_APPLICATION), linking the report to its owning product. The NAME column holds the internal short name of the concurrent program, which corresponds to the CONCURRENT_PROGRAM_NAME in the FND_CONCURRENT_PROGRAMS table. This relationship is formalized through a foreign key to FND_CONCURRENT_PROGRAMS.

Common Use Cases and Queries

A primary use case is identifying which concurrent programs are available for a specific order management transaction type or document sequence. System administrators and developers query this table to troubleshoot report submission issues or to customize the list of available reports. A common query retrieves all reports for the Order Entry application, joining to FND_CONCURRENT_PROGRAMS to get the executable filename and description.

• Sample Query: SELECT sr.report_id, sr.name, sr.report_application_id, fcp.user_concurrent_program_name FROM oe.so_reports sr, applsys.fnd_concurrent_programs fcp WHERE sr.report_application_id = fcp.application_id AND sr.name = fcp.concurrent_program_name;
• Reporting Use Case: Generating a list of all shipping document reports (Pick Slip, Packing Slip) configured in the system to audit report setup and ensure all required warehouse documents are operational.

Related Objects

As documented in the ETRM metadata, SO_REPORTS is a central parent table with several key foreign key relationships. The most significant is its link to the core Concurrent Manager table, FND_CONCURRENT_PROGRAMS, via columns REPORT_APPLICATION_ID and NAME. It is referenced as a parent by multiple child tables that define report behavior and usage:

• SO_NOTE_USAGE_ATTRIBUTES: Links reports to note usage contexts (joins on REPORT_ID).
• SO_REPORT_PARAMETERS: Stores default parameters for each report (joins on REPORT_ID).
• SO_REPORT_PRINTERS: Defines printer assignments for reports (joins on REPORT_ID).
• SO_REPORT_SET_LINES: Contains individual reports that are part of a report set (joins on REPORT_ID).
• SO_REPORT_USAGES: Maps reports to specific order transaction types or document sequences (joins on REPORT_ID).