Search Results rg_report_axis_sets




Overview
Explore in AI Chat

Overview

The RG_REPORT_AXIS_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 row and column sets, which are fundamental structural components for building financial and managerial reports. An axis set defines a specific arrangement of data dimensions, such as accounts, periods, or currencies, along a row or column axis. The table's role is to store the metadata for these reusable definitions, enabling the creation of complex, multi-dimensional report layouts without rebuilding the dimensional logic for each report.

Key Information Stored

The table stores the metadata that defines the structure and type of each axis set. The primary identifier is the AXIS_SET_ID. The unique key constraint (RG_REPORT_AXIS_SETS_UK1) highlights other critical columns: NAME for the user-defined set name, AXIS_SET_TYPE to classify the set (e.g., as a row or column structure), and APPLICATION_ID to associate it with a specific EBS application. Additional significant columns include ID_FLEX_CODE_11I and STRUCTURE_ID, which link the axis set to a specific accounting flexfield structure (like the Accounting Flexfield), and TAXONOMY_ID, which links it to an XBRL taxonomy definition for regulatory reporting.

Common Use Cases and Queries

Primary use cases involve the administration and auditing of report structures. A system administrator may query this table to identify all axis sets of a certain type or associated with a specific application before a migration or upgrade. A common diagnostic query is to list axis sets used by a specific report by joining with the RG_REPORTS table. For example:

  • Identifying all column sets: SELECT name, axis_set_id FROM rg_report_axis_sets WHERE axis_set_type = 'COLUMN';
  • Finding axis sets linked to a specific key flexfield: SELECT name FROM rg_report_axis_sets WHERE id_flex_code_11i = 'GL#';
  • Auditing usage by joining with child tables: SELECT ras.name, COUNT(ra.axis_id) FROM rg_report_axis_sets ras, rg_report_axes ra WHERE ras.axis_set_id = ra.axis_set_id GROUP BY ras.name;

Related Objects

The RG_REPORT_AXIS_SETS table has integral relationships with numerous other RG objects, as defined by its foreign keys. It is a parent table to several key reporting components:

  • RG_REPORT_AXES: Joins on AXIS_SET_ID. This table stores the individual axes (dimension members) that belong to a set.
  • RG_REPORTS: Referenced twice, for ROW_SET_ID and COLUMN_SET_ID. This defines the core row and column structure of a report definition.
  • RG_REPORT_DISPLAY_GROUPS and RG_REPORT_DISPLAY_SETS: Also referenced for ROW_SET_ID and COLUMN_SET_ID. These objects control the visual layout and display properties of reports.
  • Parent References: It references FND_ID_FLEX_STRUCTURES (on APPLICATION_ID, ID_FLEX_CODE_11I, STRUCTURE_ID) for flexfield metadata and RG_XBRL_TAXONOMIES (on TAXONOMY_ID) for regulatory reporting standards.