Results for “range_mode”

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

Overview

RG_REPORT_AXIS_CONTENTS is an Application Report Generator (RG) table in the Oracle E-Business Suite RG schema that stores the assignments of account ranges to report rows and columns. In Financial Statement Generator (FSG) reporting, a report is composed of report axes — row sets and column sets — and each axis is further decomposed into individual content lines that define which account ranges, balance types, and amounts appear in a given row or column. RG_REPORT_AXIS_CONTENTS is the physical repository for those line-level definitions.

The table is owned by the RG schema and is valid in both Oracle EBS 12.1.1 and 12.2.2. Its documented physical schema contains 246 columns, reflecting the historical practice of supporting up to 30 accounting segments plus 42 segment attributes in a single wide row. Based on the foreign key structure mined from the metadata, a heuristic Data Vault classification of link is suggested: the table resolves relationships between an axis set and a ledger, rather than acting as an independent hub or a descriptive satellite. Two foreign keys are documented: RG_REPORT_AXIS_CONTENTS.AXIS_SET_ID combined with AXIS_SEQ to RG_REPORT_AXES, and LEDGER_ID to GL_LEDGERS.

Key Information Stored

Each row represents one content line on a row or column axis. The most significant columns are:

• AXIS_SET_ID and AXIS_SEQ — the composite identifier linking the content line to its parent axis; both participate in the foreign key to RG_REPORT_AXES.
• LEDGER_ID — the ledger against which the account ranges are evaluated; foreign key to GL_LEDGERS.
• APPLICATION_ID — identifies the owning application context for the content line.
• RANGE_MODE — governs how the low/high segment range is interpreted.
• SIGN and DR_CR_NET_CODE — control the sign convention and debit/credit/net treatment of the balances selected.
• SEGMENT1_LOW / SEGMENT1_HIGH through SEGMENT30_LOW / SEGMENT30_HIGH, each paired with a SEGMENTn_TYPE column — define the account range for every accounting segment.
• SEGMENT_ATTRIBUTEn_LOW / _HIGH / _TYPE (1–42) — qualify the range using segment qualifiers and attributes.
• LEDGER_SEGMENT_TYPE and ALC_LEDGER_CURRENCY — support ledger and currency-specific selection logic.
• CONTEXT and ATTRIBUTE1–15 — the standard EBS descriptive flexfield and DFF context columns.
• Standard WHO audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

The documented surrogate key is the composite (AXIS_SET_ID, AXIS_SEQ); no separate single-column primary key is documented. LEDGER_ID is a business-key candidate via its foreign key to GL_LEDGERS.

Common Use Cases and Queries

Typical scenarios include reporting on FSG report definitions, migrating row/column sets between environments, and diagnosing why a report returns unexpected balances. A representative query joins content lines to their parent axis and ledger:

• SELECT c.AXIS_SET_ID, c.AXIS_SEQ, c.LEDGER_ID, c.SEGMENT1_LOW, c.SEGMENT1_HIGH, c.SIGN, c.DR_CR_NET_CODE FROM RG_REPORT_AXIS_CONTENTS c WHERE c.AXIS_SET_ID = :axis_set_id ORDER BY c.AXIS_SEQ;
• SELECT a.NAME, c.* FROM RG_REPORT_AXIS_CONTENTS c JOIN RG_REPORT_AXES a ON a.AXIS_SET_ID = c.AXIS_SET_ID AND a.AXIS_SEQ = c.AXIS_SEQ;
• SELECT c.* FROM RG_REPORT_AXIS_CONTENTS c JOIN GL_LEDGERS l ON l.LEDGER_ID = c.LEDGER_ID WHERE l.NAME = :ledger_name;

These patterns support data lineage reviews, FSG report documentation, and audit trails for financial statement definitions.

Related Objects

The most significant related objects, based on the documented relationships and RG module context, are:

• RG_REPORT_AXES — parent axis definitions; joined on AXIS_SET_ID and AXIS_SEQ.
• GL_LEDGERS — ledger master; joined on LEDGER_ID.
• RG_REPORT_AXIS_SETS — the row/column set that owns the axes referenced here.
• RG_REPORTS — the report definition that ultimately consumes the axes and their contents.
• RG_REPORT_COMPONENTS — component structure connecting reports to axis sets.
• GL_CODE_COMBINATIONS — the account validation source against which segment ranges are resolved.
• FND_FLEX_VALUES / FND_ID_FLEX_SEGMENTS — segment and value-set metadata used to interpret the SEGMENTn_LOW / SEGMENTn_HIGH ranges.
• RG_REPORT_AXIS_CONTENTS is referenced by FSG runtime and concurrent program logic that reads these rows to build the account selection for each row and column of a financial statement.