Search Results rg_report_display_sets




Overview
Explore in AI Chat

Overview

The RG_REPORT_DISPLAY_SETS table is a core repository object within the Oracle E-Business Suite (EBS) Application Report Generator (RG) module. It serves as the master definition table for report display sets, which are critical components for structuring and presenting the output of custom financial and operational reports. A display set acts as a container that defines the layout and organization of data on a report, primarily by linking to specific row and column axis sets. Its primary role is to provide a reusable template that dictates how data is arranged, enabling consistent report formatting and presentation across the RG module in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table stores the metadata that defines each unique report display set. The most critical columns, as indicated by the primary and unique keys, are REPORT_DISPLAY_SET_ID (the primary key) and NAME (a unique identifier for the set). Based on the provided foreign key relationships, the table also contains at least two other essential columns: COLUMN_SET_ID and ROW_SET_ID. These columns are foreign keys to the RG_REPORT_AXIS_SETS table, linking the display set to the specific definitions of its column and row axes. This structure allows the display set to act as a bridge, combining independent axis definitions into a complete report layout framework.

Common Use Cases and Queries

The primary use case is the creation and management of report layouts within the Application Report Generator. When a user defines a new report format, they reference an existing display set from this table. Common queries involve retrieving display set definitions for reporting, auditing, or troubleshooting. For instance, to list all display sets with their associated axis names, a developer might use a query such as:

  • SELECT ds.name AS display_set_name, ras_col.name AS column_set, ras_row.name AS row_set FROM rg_report_display_sets ds, rg_report_axis_sets ras_col, rg_report_axis_sets ras_row WHERE ds.column_set_id = ras_col.report_axis_set_id AND ds.row_set_id = ras_row.report_axis_set_id;

Another critical scenario is identifying which reports or report requests utilize a specific display set, which is essential for impact analysis before modifying a display set definition.

Related Objects

RG_REPORT_DISPLAY_SETS is a central hub with several key dependencies, as shown by its foreign key constraints. It is directly referenced by the RG_REPORTS, RG_REPORT_DISPLAYS, and RG_REPORT_REQUESTS tables, meaning it is fundamental to the core report definition, display logic, and runtime execution. Conversely, it references the RG_REPORT_AXIS_SETS table twice (for column and row sets), forming the foundational structure of the report layout. Understanding these relationships is crucial for custom reporting extensions, data fixes, or performance tuning within the Report Generator.