Search Results so_report_set_lines




Overview
Explore in AI Chat

Overview

The SO_REPORT_SET_LINES table is a core data object within the Order Entry (OE) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as the detail table for defining and storing the composition of a document set, which is a logical grouping of concurrent reports. Each record in this table represents a specific report that has been assigned to a parent document set. The table's primary role is to manage the sequence and membership of reports within a set, enabling the streamlined execution of multiple related documents, such as a pick slip, packing slip, and commercial invoice, as a single concurrent request.

Key Information Stored

The table's structure is designed to link a report to its parent set and define its execution order. The critical columns include REPORT_SET_LINE_ID, which serves as the unique primary key identifier for each line. The REPORT_SET_ID column is a foreign key that links the line to its parent document set defined in the SO_REPORT_SETS table. The REPORT_ID column is a foreign key that identifies the specific concurrent report from the SO_REPORTS table to be included. Finally, the REPORT_SEQUENCE column dictates the order in which the reports within the set are processed and printed. Together, REPORT_SET_ID and REPORT_SEQUENCE form a unique key (SO_REPORT_SET_LINES_UK1), ensuring no duplicate sequence numbers exist within a given set.

Common Use Cases and Queries

The primary use case is the configuration and execution of predefined document sets for order fulfillment cycles. Administrators use this data to build sets via the Oracle Forms interface, while runtime processes query it to determine which reports to launch. A common reporting need is to audit the composition of all document sets. A sample query for this purpose would join SO_REPORT_SET_LINES with its parent tables:

  • SELECT srs.report_set_name, sr.report_name, srsl.report_sequence
  • FROM oe.so_report_set_lines srsl,
  • oe.so_report_sets srs,
  • oe.so_reports sr
  • WHERE srsl.report_set_id = srs.report_set_id
  • AND srsl.report_id = sr.report_id
  • ORDER BY srs.report_set_name, srsl.report_sequence;

This query lists all document sets, their constituent reports, and the print sequence, which is vital for troubleshooting fulfillment document workflows.

Related Objects

SO_REPORT_SET_LINES maintains integral relationships with two key parent tables via foreign key constraints. The REPORT_SET_ID column references SO_REPORT_SETS (SO_REPORT_SETS_PK), which stores the header definition of the document set, including its name and description. The REPORT_ID column references SO_REPORTS (SO_REPORTS_PK), the master table of all available concurrent reports in the Order Entry module. This table is central to the document set functionality and is referenced by the standard Oracle reports and APIs that manage and execute these sets, such as those invoked during the Pick Release, Ship Confirm, and Print Documents processes.