Search Results rg_report_axes




Overview
Explore in AI Chat

Overview

The RG_REPORT_AXES table is a core data object within the Oracle E-Business Suite Application Report Generator (RG) module. It serves as the structural definition table for the rows and columns of reports generated by the system. In essence, this table stores the metadata that defines the dimensional axes of a report, specifying the sequence, type, and attributes of each row or column header. Its primary role is to provide the framework upon which report content, calculations, and exceptions are built, acting as a critical link between the high-level report definition and the detailed data points.

Key Information Stored

The table's structure is centered on uniquely identifying and ordering axes within a specific report axis set. The primary key is a composite of AXIS_SET_ID and AXIS_SEQ, which together define a specific axis position within a report layout. Important columns include AXIS_SET_ID, which links to the RG_REPORT_AXIS_SETS table to identify the parent report structure, and AXIS_SEQ, which dictates the order of the axis. Other significant foreign key columns are STANDARD_AXIS_ID (linking to RG_REPORT_STANDARD_AXES for predefined axes), UNIT_OF_MEASURE_ID (linking to FND_CURRENCIES), and ELEMENT_ID (linking to RG_XBRL_ELEMENTS for financial reporting compliance). These relationships allow axes to be associated with standard definitions, currencies, and XBRL taxonomy elements.

Common Use Cases and Queries

This table is primarily accessed for report definition analysis, troubleshooting, and generating metadata reports. A common use case is to retrieve the complete axis structure for a specific report to understand its layout. For example, a developer might run a query to list all axes for a given AXIS_SET_ID, ordered by their sequence, and joined with descriptive information from related tables like RG_REPORT_STANDARD_AXES or FND_CURRENCIES. Another typical scenario involves diagnosing report calculation or exception errors by verifying that the axis sequences referenced in the RG_REPORT_CALCULATIONS or RG_REPORT_EXCEPTIONS tables actually exist in RG_REPORT_AXES. Sample SQL often involves joins to RG_REPORT_AXIS_SETS to filter by report and to the various foreign key tables to get descriptive names.

Related Objects

RG_REPORT_AXES is a central hub with numerous documented foreign key relationships, as per the provided metadata. Key related objects include:

  • RG_REPORT_AXIS_SETS: The parent table. Joined via RG_REPORT_AXES.AXIS_SET_ID.
  • RG_REPORT_STANDARD_AXES: Provides standard axis definitions. Joined via RG_REPORT_AXES.STANDARD_AXIS_ID.
  • FND_CURRENCIES: Defines the unit of measure. Joined via RG_REPORT_AXES.UNIT_OF_MEASURE_ID.
  • RG_XBRL_ELEMENTS: For XBRL reporting taxonomy. Joined via RG_REPORT_AXES.ELEMENT_ID.
  • RG_REPORT_AXIS_CONTENTS: Contains the specific members or data for each axis. Foreign key references RG_REPORT_AXES (AXIS_SET_ID, AXIS_SEQ).
  • RG_REPORT_CALCULATIONS: Defines calculations that reference axes for their range (LOW/SEQ_HIGH) or specific axis (AXIS_SEQ).
  • RG_REPORT_EXCEPTIONS and RG_REPORT_EXCEPTION_FLAGS: Define exceptions and their flags on specific axes.