Search Results rg_report_sets




Overview
Explore in AI Chat

Overview

The RG_REPORT_SETS table is a core repository within the Oracle E-Business Suite Application Report Generator (RG) module. It serves as the master definition table for report sets, which are logical groupings of individual reports. A report set is a fundamental construct in the Report Generator, allowing users to schedule, run, and manage multiple related reports as a single, consolidated unit. This object is critical for the configuration and execution of financial and operational reporting processes, particularly those involving the consolidation of data across different applications or currencies.

Key Information Stored

The table stores the metadata that defines a report set's identity, structure, and processing parameters. The primary columns include REPORT_SET_ID, which is the unique numeric identifier and primary key. The NAME column, combined with APPLICATION_ID, forms a unique key (RG_REPORT_SETS_UK1), ensuring report set names are unique within a specific Oracle application context. The APPLICATION_ID links the report set to its parent application module. Other significant columns include UNIT_OF_MEASURE_ID, which references FND_CURRENCIES to define the default currency for the report set, and ID_FLEX_CODE_11I and STRUCTURE_ID, which are foreign keys to FND_ID_FLEX_STRUCTURES. These latter columns define the key flexfield structure (such as Accounting Flexfield or Category Flexfield) associated with the reports in the set, governing the segment validation and reporting dimensions.

Common Use Cases and Queries

A primary use case is auditing and managing the inventory of defined report sets across the EBS instance. System administrators often query this table to understand reporting configurations before migrations or upgrades. A typical query retrieves basic report set definitions:

  • SELECT report_set_id, name, application_id FROM rg.rg_report_sets WHERE application_id = 101 ORDER BY name;

Another common scenario involves troubleshooting report execution by joining to the child table RG_REPORT_REQUESTS to analyze run history. Developers may also query this table to programmatically identify report sets for integration with custom scheduling tools or to clone report set definitions by inserting new records based on existing templates, carefully managing the unique key constraints.

Related Objects

The RG_REPORT_SETS table has integral relationships with several other EBS objects. It is the parent table to RG_REPORT_REQUESTS via the REPORT_SET_ID foreign key; this child table logs each execution instance of a report set. For validation and reference data, it depends on FND_ID_FLEX_STRUCTURES (for flexfield definitions) and FND_CURRENCIES (for the unit of measure). The table is central to the Report Generator's data model, and its definitions are accessed through the standard RG reporting interfaces and APIs. Direct manipulation of data in this table outside of these sanctioned interfaces is strongly discouraged, as it may compromise application integrity.