Search Results rg_report_axis_contents




Overview
Explore in AI Chat

Overview

The RG_REPORT_AXIS_CONTENTS table is a core data structure within the Oracle E-Business Suite Application Report Generator (RG) module. Its primary function is to define the financial content of management reports by storing the specific assignments of General Ledger account ranges to the rows and columns of a report layout. This table acts as the critical link between the structural definition of a report axis (rows/columns) and the actual accounting data from a specific ledger, enabling the dynamic generation of financial statements, such as balance sheets and income statements, with precise account-level detail.

Key Information Stored

While the full column list is not detailed in the provided metadata, the documented foreign key relationships reveal its essential components. The table stores records that associate an account range (or single account) with a specific position in a report's axis set. Key columns inferred and documented include AXIS_SET_ID and AXIS_SEQ, which together identify a unique row or column within a report definition (RG_REPORT_AXES). The LEDGER_ID column specifies the source ledger (GL_LEDGERS) for the account data. Additional columns, not explicitly listed but standard for such a table, would define the account range (e.g., from and to account values, segment qualifiers) and potentially display attributes, sequencing, and calculation rules for the assigned financial data.

Common Use Cases and Queries

This table is central to the runtime execution and auditing of RG reports. A primary use case is tracing which ledger accounts populate a specific line item on a generated financial report. For instance, to analyze the composition of a "Cash and Equivalents" row, a consultant would query this table to find the assigned account ranges. Common SQL patterns involve joining to RG_REPORT_AXES for axis descriptions and GL_LEDGERS for ledger information.

  • Sample Query to List Account Assignments for a Report:
    SELECT rac.axis_set_id, rac.axis_seq, rac.ledger_id, gl.name ledger_name
    FROM rg_report_axis_contents rac,
    gl_ledgers gl
    WHERE rac.ledger_id = gl.ledger_id
    AND rac.axis_set_id = :p_axis_set_id
    ORDER BY rac.axis_seq;

Related Objects

The table maintains documented foreign key relationships with two other critical EBS objects, forming the backbone of the Report Generator's data model.

  • RG_REPORT_AXES: This is the parent table for the report axis definition. The relationship is established via the composite foreign key on columns AXIS_SET_ID and AXIS_SEQ. Each record in RG_REPORT_AXIS_CONTENTS must correspond to a valid row or column definition in RG_REPORT_AXES.
  • GL_LEDGERS: This relationship ties the report content to a specific accounting ledger. The foreign key on column LEDGER_ID references GL_LEDGERS.LEDGER_ID, ensuring that the assigned account ranges are sourced from a valid, accessible ledger within the General Ledger module.