Search Results rg_report_content_sets




Overview
Explore in AI Chat

Overview

The RG_REPORT_CONTENT_SETS table is a core repository table within the Oracle E-Business Suite Application Report Generator (RG) module. It serves as the master definition table for content sets, which are fundamental building blocks for generating structured reports. A content set defines the specific data content, parameters, and structural rules for a report, essentially acting as a reusable template. This table's role is to store the metadata for these definitions, enabling the RG engine to correctly assemble and execute report requests across various applications.

Key Information Stored

The table's primary columns, as indicated by its primary and unique keys, are critical for identifying and managing content set definitions. The CONTENT_SET_ID column is the primary key, providing a unique numeric identifier for each content set. The NAME column stores the unique name of the content set, while the APPLICATION_ID column (referencing FND_APPLICATION) identifies the Oracle EBS application module to which the content set belongs. Together, NAME and APPLICATION_ID form a unique key (RG_REPORT_CONTENT_SETS_UK). Additional important columns include ID_FLEX_CODE_11I and STRUCTURE_ID, which link the content set to a specific key flexfield structure (via FND_ID_FLEX_STRUCTURES), defining the accounting or other segmental structure used for data organization within the report.

Common Use Cases and Queries

This table is primarily accessed for administrative and diagnostic purposes. Common scenarios include identifying all content sets available for a specific application, troubleshooting report generation issues by verifying content set definitions, and auditing report usage. A typical query would join with FND_APPLICATION to retrieve readable application names:

  • SELECT rcs.name, rcs.content_set_id, fa.application_short_name FROM rg_report_content_sets rcs, fnd_application fa WHERE rcs.application_id = fa.application_id ORDER BY fa.application_short_name, rcs.name;

Another critical use case is tracing the lineage of a report request or content override back to its source definition by querying on the CONTENT_SET_ID.

Related Objects

As documented in the foreign key relationships, RG_REPORT_CONTENT_SETS is a central parent table referenced by several key reporting objects:

  • RG_REPORTS: References RG_REPORT_CONTENT_SETS via CONTENT_SET_ID. This links a specific report definition to its underlying content set.
  • RG_REPORT_REQUESTS: References RG_REPORT_CONTENT_SETS via CONTENT_SET_ID. This ties each submitted report request instance to the content set that defines its data.
  • RG_REPORT_CONTENT_OVERRIDES: References RG_REPORT_CONTENT_SETS via CONTENT_SET_ID. This allows for customized content rules that override the standard set for specific needs.
  • FND_ID_FLEX_STRUCTURES: Referenced by RG_REPORT_CONTENT_SETS via the columns APPLICATION_ID, ID_FLEX_CODE_11I, and STRUCTURE_ID. This provides the flexfield structure metadata used by the content set.