Search Results display_units




Overview
Explore in AI Chat

Overview

RG_REPORT_AXES is a core configuration table in the Oracle E-Business Suite Application Report Generator (RG) module, stored in the RG schema. It holds the row and column axis definitions that drive the layout of generated financial and management reports. In Oracle EBS 12.1.1 and 12.2.2, this table defines how report data is structured across axes, including formatting, currency context, XBRL element mapping, and calculation participation. Functionally, it serves as the axis-level metadata repository that sits between axis set headers and the individual report contents, calculations, exceptions, and exception flags that consume it.

From a Data Vault modeling perspective, the heuristic classification of RG_REPORT_AXES is a hub. This reflects its role as a central anchor for axis identity and relationships, with the foreign keys fanning outward to reference and dependent tables.

Key Information Stored

The primary key is RG_REPORT_AXES_PK, composed of AXIS_SET_ID and AXIS_SEQ. A unique index, RG_REPORT_AXES_U1 (AXIS_SET_ID, AXIS_SEQ, ZD_EDITION_NAME), acts as the business-key candidate, incorporating the edition dimension used in later releases. The table documents 60 columns; the most significant include:

Common Use Cases and Queries

Typical use cases include auditing report layouts, migrating axis definitions between environments, and troubleshooting calculations. A common query joins axis headers to their contents:

SELECT a.AXIS_SET_ID, a.AXIS_SEQ, a.AXIS_NAME, a.AXIS_TYPE, c.CONTENT_VALUE
FROM RG.RG_REPORT_AXES a, RG.RG_REPORT_AXIS_CONTENTS c
WHERE a.AXIS_SET_ID = c.AXIS_SET_ID AND a.AXIS_SEQ = c.AXIS_SEQ;

To inspect calculation dependencies, join RG_REPORT_CALCULATIONS on AXIS_SET_ID and AXIS_SEQ. Formatting and currency analysis can join FND_CURRENCIES via UNIT_OF_MEASURE_ID.

Related Objects

Significant dependent and referenced objects include:

  • RG_REPORT_AXIS_CONTENTS — references AXIS_SET_ID and AXIS_SEQ, holding content per axis position.
  • RG_REPORT_CALCULATIONS — references AXIS_SET_ID with AXIS_SEQ, AXIS_SEQ_LOW, and AXIS_SEQ_HIGH for range calculations.
  • RG_REPORT_EXCEPTIONS and RG_REPORT_EXCEPTION_FLAGS — reference AXIS_SET_ID and AXIS_SEQ to define exception logic.
  • RG_REPORT_STANDARD_AXES — referenced via STANDARD_AXIS_ID.
  • FND_CURRENCIES — referenced via UNIT_OF_MEASURE_ID.
  • RG_REPORT_AXIS_SETS — parent via AXIS_SET_ID.
  • RG_XBRL_ELEMENTS — referenced via ELEMENT_ID for XBRL tagging.