Search Results display_precision

Overview

The APPS.RG_REPORT_AXES_V view belongs to the Application Report Generator (RG) product family in Oracle E-Business Suite. It exposes the row-level definition of report axes, the structural building blocks that determine how financial and non-financial data is laid out across the rows, columns, and pages of a generated report. In release 12.1.1 and 12.2.2 this object retains its original RG lineage while incorporating extensions for XBRL tagging, standard axis translation, and display formatting introduced to support contemporary reporting and regulatory submission requirements.

Because the view is defined over the RG_REPORT_AXES synonym and enriches it with decoded meanings from RG_LOOKUPS, translated labels from RG_REPORT_STANDARD_AXES_TL, and optional XBRL element metadata, it functions as the primary read interface for report designers and integrators who build, inspect, or migrate report axis configurations. The view is registered under the APPS schema and is reported as VALID, confirming that its underlying dependencies resolved cleanly at the time of the ETRM 12.2.2 snapshot.

Underlying Base Objects

The documented base objects referenced by RG_REPORT_AXES_V are RG_REPORT_AXES (SYNONYM), RG_REPORT_STANDARD_AXES_TL (SYNONYM), RG_XBRL_ELEMENTS (SYNONYM), and RG_LOOKUPS (VIEW). The relationship is expressed through a set of outer joins.

• RG_REPORT_AXES supplies the driving rows; every column listed in the column list originates from this source unless noted otherwise.
• RG_REPORT_STANDARD_AXES_TL is joined via STANDARD_AXIS_ID with LANGUAGE(+) = USERENV('LANG'), producing the translated STANDARD_AXIS_NAME for the session language.
• RG_LOOKUPS is joined twice. L1 decodes DISPLAY_LEVEL against lookup type GL_DISPLAY_LEVEL, and L2 decodes DISPLAY_UNITS against lookup type DISPLAY_UNITS (matched on TO_CHAR(DISPLAY_UNITS)). Both joins are outer, so missing lookup values produce NULL meanings rather than dropping rows.
• RG_XBRL_ELEMENTS is joined via ELEMENT_ID(+) to supply ELEMENT_NAME and the NVL(ELEMENT_LABEL, ELEMENT_NAME) display value. The derived ROW_ID alias replaces the raw ROWID pseudo-column.

Key Columns

The column list is extensive and can be grouped functionally. Identity and audit columns include ROW_ID, APPLICATION_ID, AXIS_SET_ID, AXIS_SEQ, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN. Structural attributes such as AXIS_TYPE, AXIS_NAME, AMOUNT_ID, STANDARD_AXIS_ID, STANDARD_AXIS_NAME, WIDTH, POSITION, STRUCTURE_ID, UNIT_OF_MEASURE_ID, PARAMETER_NUM, PERIOD_OFFSET, and DESCRIPTION control how the axis is positioned and parameterized.

Rendering controls include DISPLAY_FLAG, BEFORE_AXIS_STRING, AFTER_AXIS_STRING, NUMBER_CHARACTERS_INDENTED, PAGE_BREAK_AFTER_FLAG, PAGE_BREAK_BEFORE_FLAG, NUMBER_LINES_SKIPPED_BEFORE, NUMBER_LINES_SKIPPED_AFTER, DISPLAY_LEVEL (with decoded L1.MEANING), DISPLAY_ZERO_AMOUNT_FLAG, DISPLAY_UNITS (with decoded L2.MEANING), DISPLAY_FORMAT, FORMAT_BEFORE_TEXT, FORMAT_AFTER_TEXT, FORMAT_MASK_WIDTH, and DISPLAY_PRECISION.

The sign-related flags are central to financial column presentation: CHANGE_SIGN_FLAG inverts the sign of displayed values, while CHANGE_VARIANCE_SIGN_FLAG controls sign handling for variance calculations. Related financial columns include CALCULATION_PRECEDENCE_FLAG, PERCENTAGE_DIVISOR_SEQ, TRANSACTION_FLAG, SEGMENT_OVERRIDE_VALUE, and OVERRIDE_ALC_LEDGER_CURRENCY. Finally, ELEMENT_ID, ELEMENT_NAME, and the derived element label provide XBRL mapping, and CONTEXT plus ATTRIBUTE1 through ATTRIBUTE15 provide descriptive flexibility.

Common Use Cases and Queries

Typical uses include auditing axis definitions for a report set, reviewing sign and variance behavior, and extracting XBRL mappings. A representative query lists axes with their decoded display level for the current language:

SELECT axis_set_id, axis_seq, axis_name, axis_type,
       change_sign_flag, change_variance_sign_flag,
       display_level, meaning
FROM   apps.rg_report_axes_v
WHERE  axis_set_id = :axis_set_id
ORDER  BY axis_seq;

A second query isolates the sign-flip configuration for verification during migration or troubleshooting of reporting variances:

SELECT axis_name, display_format, change_sign_flag,
       change_variance_sign_flag, element_name, element_label
FROM   apps.rg_report_axes_v
WHERE  change_sign_flag = 'Y'
ORDER  BY axis_set_id, axis_seq;

Because the view is read-only and fully decoded, it is well suited for custom extracts, diagnostic reports, and feed programs that need axis metadata without navigating the base tables directly.