Search Results report_set_line_id

Overview

The table WSH_REPORT_SET_LINES is a core data object within the Shipping Execution (WSH) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as the child table that defines the specific reports included within a report set. A report set is a grouping of shipping-related documents (e.g., packing slips, bills of lading, commercial invoices) that can be generated and printed collectively for a shipment or delivery. This table is essential for managing the multi-document output requirements of complex shipping and logistics operations, enabling users to configure and execute batches of reports efficiently.

Key Information Stored

While the provided ETRM metadata does not list individual columns, the structure is defined by its primary and foreign keys. The central column is REPORT_SET_LINE_ID, which serves as the unique identifier for each line (Primary Key: WSH_REPORT_SET_LINES_PK). The REPORT_SET_ID column is a foreign key that links each line to its parent report set definition in the WSH_REPORT_SETS table. Typical columns in this table, based on standard EBS design patterns, would include the sequence number for ordering reports within the set, the application ID and concurrent program ID of the specific report to execute, and parameters for the report execution. The table stores the configuration of which reports and in what order they comprise a defined report set.

Common Use Cases and Queries

The primary use case is the generation of a complete shipping document package. When a user initiates a print action for a shipment, the application queries this table to determine all reports that must be run. Common queries involve joining to the parent WSH_REPORT_SETS table to list all configured lines for a specific report set or for a set used by a particular shipping entity. A sample SQL pattern to retrieve this information would be:

• SELECT rs.report_set_name, rsl.* FROM wsh_report_sets rs, wsh_report_set_lines rsl WHERE rs.report_set_id = rsl.report_set_id ORDER BY rsl.sequence_num;

This table is also critical for troubleshooting missing documents in output or for auditing the historical configuration of report sets via custom reports.

Related Objects

The table has a direct, documented foreign key relationship with the WSH_REPORT_SETS table, which is its primary parent object.

• WSH_REPORT_SETS: This is the parent table containing the header definition of the report set (e.g., name, description). The relationship is defined as WSH_REPORT_SET_LINES.REPORT_SET_ID → WSH_REPORT_SETS.REPORT_SET_ID. All report set lines must belong to a valid entry in this table.

While not listed in the provided metadata, this table is also integrally related to the concurrent request and output post-processing mechanisms within Oracle EBS, as each line typically results in a submitted concurrent request when the report set is executed.