Search Results report_display_set_id




Overview
Explore in AI Chat

Overview

The RG_REPORT_DISPLAYS table is a core data object within the Application Report Generator (RG) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as a junction table, managing the many-to-many assignments between report display groups and report display sets. This table is essential for defining the layout and structure of reports generated by the RG engine, as it dictates which row and column display groups are assembled into a specific display set for output. Its integrity is enforced by primary and unique keys, ensuring consistent and non-duplicative report configurations.

Key Information Stored

The table's primary columns store identifiers that link the various components of a report display definition. The REPORT_DISPLAY_ID serves as the primary key for each unique assignment record. The REPORT_DISPLAY_SET_ID is a crucial foreign key that links to the RG_REPORT_DISPLAY_SETS table, identifying the specific display set being configured. The SEQUENCE column determines the order in which the assigned groups are processed or displayed. Finally, the ROW_GROUP_ID and COLUMN_GROUP_ID are foreign keys linking to the RG_REPORT_DISPLAY_GROUPS table, specifying the exact row and column groups that constitute the report's dimensional layout within the set.

Common Use Cases and Queries

This table is primarily accessed for report definition analysis, troubleshooting, and auditing. A common query involves retrieving the complete structure of a specific report display set, which a user might search for using the REPORT_DISPLAY_SET_ID. For instance, to audit all group assignments for a given set, one would execute a query joining RG_REPORT_DISPLAYS to RG_REPORT_DISPLAY_GROUPS twice (for rows and columns) and filter on the desired REPORT_DISPLAY_SET_ID. Another typical use case is generating a list of all display sets that utilize a particular display group, which involves querying this table for a specific ROW_GROUP_ID or COLUMN_GROUP_ID. Administrators may also query this table to understand dependencies before modifying or purging display group definitions.

Related Objects

The RG_REPORT_DISPLAYS table maintains defined foreign key relationships with two other core RG tables, as documented in the ETRM metadata.

  • RG_REPORT_DISPLAY_SETS: Linked via RG_REPORT_DISPLAYS.REPORT_DISPLAY_SET_ID. This is the parent table for the display set definition.
  • RG_REPORT_DISPLAY_GROUPS: Linked via two separate foreign keys. The RG_REPORT_DISPLAYS.ROW_GROUP_ID column references a group used for row definitions, while the RG_REPORT_DISPLAYS.COLUMN_GROUP_ID column references a group used for column definitions. Both point to the same parent table.