Search Results wsh_report_sets




Overview
Explore in AI Chat

Overview

The WSH_REPORT_SETS table 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 master definition table for shipping report sets. A report set is a logical grouping of individual shipping documents, such as bills of lading, packing slips, or commercial invoices, that can be submitted and printed together as a single job. This table is essential for managing the consolidated printing and distribution of shipping documentation, streamlining post-delivery and shipping confirmation processes.

Key Information Stored

The table's primary purpose is to store header-level information for each defined report set. Its structure is anchored by the REPORT_SET_ID column, which serves as the unique primary key identifier for each report set. While the provided ETRM metadata does not list all columns, standard implementation suggests the table typically stores metadata such as the report set name, description, creation date, and the user who created it. The foreign key relationship defined in the metadata indicates that the REPORT_SET_ID is the critical link to the detailed composition of the report set, which is stored in the related WSH_REPORT_SET_LINES table.

Common Use Cases and Queries

The primary use case involves querying and managing the definitions of shipping document groupings for operational reporting and audit purposes. Common activities include identifying all report sets created within a specific timeframe or listing the report sets available for a particular shipping transaction. A fundamental query retrieves the basic header information for all report sets, often joined with the lines table to see a complete picture.

  • Sample Query to List Report Sets:
    SELECT REPORT_SET_ID, NAME, CREATION_DATE
    FROM WSH.WSH_REPORT_SETS
    ORDER BY CREATION_DATE DESC;
  • Sample Query to Join with Report Set Lines:
    SELECT rs.REPORT_SET_ID, rs.NAME, rsl.REPORT_ID
    FROM WSH.WSH_REPORT_SETS rs,
    WSH.WSH_REPORT_SET_LINES rsl
    WHERE rs.REPORT_SET_ID = rsl.REPORT_SET_ID
    AND rs.NAME = '<Report_Set_Name>';

Related Objects

The WSH_REPORT_SETS table has a direct and critical relationship with the WSH_REPORT_SET_LINES table, as documented by the foreign key. The WSH_REPORT_SET_LINES table holds the specific reports (e.g., individual document types) that belong to each set defined in WSH_REPORT_SETS. This table is also intrinsically linked to the shipping transaction and document submission processes within the WSH module. While not explicitly listed in the provided metadata, it is commonly referenced by standard Oracle APIs and concurrent program definitions responsible for submitting and printing shipping documents, forming the backbone of the shipping documentation framework.