Search Results rg_report_display_groups




Overview
Explore in AI Chat

Overview

The RG_REPORT_DISPLAY_GROUPS table is a core repository within the Application Report Generator (RG) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the master definition table for report display groups, which are fundamental constructs for organizing and presenting data in the Report Generator. A display group defines a specific layout or view of a report by associating a set of rows and a set of columns, thereby establishing the two-dimensional matrix structure for report output. This table is essential for the runtime execution and rendering of custom financial and operational reports built using the EBS Report Generator toolset.

Key Information Stored

The table stores metadata that defines each unique display group configuration. While the full column list is not detailed in the provided metadata, the primary and foreign key relationships reveal its critical components. The primary identifier is REPORT_DISPLAY_GROUP_ID. A unique key on the NAME column ensures each display group has a distinct, recognizable identifier for user reference. Crucially, the table stores foreign key references to axis sets via the COLUMN_SET_ID and ROW_SET_ID columns. These columns link to the RG_REPORT_AXIS_SETS table, defining which sets of data elements (axes) are used for the column and row dimensions of the report layout, respectively. This linkage is the core of the display group's function.

Common Use Cases and Queries

This table is primarily accessed by the Report Generator engine during report execution. Common administrative and diagnostic tasks involve querying display group definitions to understand report structure or troubleshoot issues. A typical query would join to the axis sets table to see the full layout definition.

  • Identifying Display Groups for a Report: To list all display groups and their associated row and column sets: SELECT rdg.name, rdg.report_display_group_id, ras_row.name as row_set, ras_col.name as column_set FROM rg_report_display_groups rdg, rg_report_axis_sets ras_row, rg_report_axis_sets ras_col WHERE rdg.row_set_id = ras_row.report_axis_set_id AND rdg.column_set_id = ras_col.report_axis_set_id;
  • Finding Reports Using a Specific Display Group: To locate all report displays that utilize a particular group for rows or columns, one would join from this table to RG_REPORT_DISPLAYS using the documented foreign key relationships on ROW_GROUP_ID and COLUMN_GROUP_ID.

Related Objects

The RG_REPORT_DISPLAY_GROUPS table has defined relationships with several key Report Generator tables, as per the provided metadata.

  • Referenced Tables (Outgoing Foreign Keys):
    • RG_REPORT_AXIS_SETS: The table is referenced twice. RG_REPORT_DISPLAY_GROUPS.COLUMN_SET_ID links to an axis set defining the report's columns. RG_REPORT_DISPLAY_GROUPS.ROW_SET_ID links to an axis set defining the report's rows.
  • Referencing Tables (Incoming Foreign Keys):
    • RG_REPORT_DISPLAYS: This central report definition table references RG_REPORT_DISPLAY_GROUPS twice. RG_REPORT_DISPLAYS.ROW_GROUP_ID and RG_REPORT_DISPLAYS.COLUMN_GROUP_ID both store REPORT_DISPLAY_GROUP_ID values to define the row and column groups for a specific report display.