Results for “rg_report_axis_sets”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The RG_REPORT_AXIS_SETS table is a core data object within the Application Report Generator (RG) product in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores row and column set definitions that drive the layout of generated financial and management reports. A row set defines the vertical structure of a report, while a column set defines its horizontal structure; both are persisted as axis sets within this single table and differentiated by the AXIS_SET_TYPE column. This design allows the report generator to reuse a common physical container for what are logically distinct report-building constructs.

From a Data Vault modeling perspective, the mined foreign key structure and primary key behavior suggest that RG_REPORT_AXIS_SETS behaves as a hub. The AXIS_SET_ID surrogate key uniquely identifies each axis set, and the table serves as the integration point for numerous dependent tables across the RG module and selected localization modules. Downstream tables reference axis set records rather than duplicating row or column definitions, reinforcing the hub classification.

Key Information Stored

The table contains 38 documented columns. The most significant include:

• AXIS_SET_ID — Surrogate primary key (RG_REPORT_AXIS_SETS_PK), the internal identifier for each axis set record.
• NAME — The user-facing name of the row or column set; forms part of the business-key unique index RG_REPORT_AXIS_SETS_UK1 alongside AXIS_SET_TYPE and APPLICATION_ID.
• AXIS_SET_TYPE — Distinguishes whether the record represents a row set or a column set, and participates in the same unique business key.
• APPLICATION_ID — Identifies the owning application; also part of the unique business key and a foreign key to FND_ID_FLEX_STRUCTURES.
• DESCRIPTION — Free-text description of the axis set.
• ROW_SET_TITLE — Title text applied when the axis set is used as a row set.
• COLUMN_SET_HEADER — Header text applied when the axis set is used as a column set.
• SEGMENT_NAME, ID_FLEX_CODE_11I, STRUCTURE_ID, CONTEXT — Relate the axis set to an accounting flexfield structure and its segments, enabling row and column definitions to map to chart of accounts components.
• ID_FLEX_CODE — Flexfield code used in the current release context.
• PERIOD_SET_NAME — Identifies the accounting period set associated with the axis set.
• TAXONOMY_ID — Foreign key to RG_XBRL_TAXONOMIES, linking the axis set to XBRL taxonomy definitions.
• SECURITY_FLAG and DISPLAY_IN_LIST_FLAG — Control visibility and security behavior.
• SEEDED_NAME — Marks seeded (Oracle-provided) definitions.
• ZD_EDITION_NAME — Editioning column used in the 12.2.2 schema; participates in unique indexes U1 and U2.

Standard audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and fifteen ATTRIBUTE columns provide descriptive flexfield support and change tracking.

Common Use Cases and Queries

Typical use cases include identifying all row sets or column sets for a given application, resolving the row and column definitions referenced by a report, and auditing seeded versus user-defined definitions. A representative query lists column sets for an application:

• SELECT axis_set_id, name, description FROM rg_report_axis_sets WHERE axis_set_type = 'C' AND application_id = :app_id;
• SELECT r.name, a.name FROM rg_reports r JOIN rg_report_axis_sets a ON r.row_set_id = a.axis_set_id;

Reporting scenarios include XBRL taxonomy mapping (joining TAXONOMY_ID to RG_XBRL_TAXONOMIES), flexfield segment analysis (joining STRUCTURE_ID to FND_ID_FLEX_STRUCTURES), and impact analysis of display groups or display sets that reference a specific axis set.

Related Objects

RG_REPORT_AXIS_SETS is referenced by several dependent tables and itself references core flexfield and taxonomy objects:

• RG_REPORTS — References column and row sets via COLUMN_SET_ID and ROW_SET_ID.
• RG_REPORT_AXES — Child table referencing AXIS_SET_ID.
• RG_REPORT_DISPLAY_GROUPS — References COLUMN_SET_ID and ROW_SET_ID.
• RG_REPORT_DISPLAY_SETS — References COLUMN_SET_ID and ROW_SET_ID.
• FND_ID_FLEX_STRUCTURES — Parent for APPLICATION_ID, ID_FLEX_CODE_11I, and STRUCTURE_ID.
• RG_XBRL_TAXONOMIES — Parent for TAXONOMY_ID.
• JA_CN_CFS_ASSIGNMENTS_ALL, JA_CN_CFS_CALCULATIONS_GT, JA_CN_CFS_ROW_CGS_GT — Localization (China CFS) tables referencing AXIS_SET_ID.