Results for “gl_je_cons_balances_v”

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

Overview

The GL_JE_CONS_BALANCES_V view is an APPS-owned, VALID database view within the Oracle General Ledger (GL) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes consolidated journal entry balance information by joining balance data to journal import reference data. The view is primarily intended to support consolidation processing and reporting, particularly the retrieval of balances that were generated through the General Ledger consolidation workflow and tracked via import references.

The column ENTERED_QUARTER_TO_DATE is one of the principal measures exposed by this view. It represents the entered (functional, before translation) balance accumulated from the beginning of the current quarter through the end of the current period, expressed in the ledger currency. It is derived from the two GL_BALANCES quantities QUARTER_TO_DATE_DR and QUARTER_TO_DATE_CR, combined with the current period net activity and divided by the factor returned by GLR03300_PKG.GET_FACTOR.

Underlying Base Objects

The view is defined over three base objects and one packaged function, all referenced within the APPS schema:

• GL_BALANCES (via the GL_BALANCES synonym) — provides the core balance rows aliased as BA, including the period-to-date, quarter-to-date, year-to-date, project-to-date, and translated flag columns used in the calculations.
• GL_IMPORT_REFERENCES (via its synonym) — aliased as IR, supplies the consolidation linkage: REFERENCE_1 (consolidation ID), REFERENCE_3 (code combination), REFERENCE_4 (translation flag), REFERENCE_5 (budget version), REFERENCE_7 (ledger), REFERENCE_8 (period), REFERENCE_9 (amount type), and REFERENCE_10 (consolidated amount).
• GL_LEDGERS (via its synonym) — aliased as L, used to match the ledger and determine the ledger currency for translated-flag logic.
• GLR03300_PKG — a package whose GET_FACTOR function normalizes monetary amounts to the correct precision and scale.

Rows are matched on ledger, code combination, period, translation flag, and budget version, ensuring that each consolidation import reference aligns with the corresponding GL balance row.

Key Columns

• LEDGER_ID — identifies the ledger for the balance row.
• CODE_COMBINATION_ID — the accounting flexfield combination.
• CONSOLIDATION_ID — derived from IR.REFERENCE_1, identifying the consolidation run.
• PERIOD_NAME and CURRENCY_CODE — the accounting period and currency.
• TRANSLATED_FLAG, BUDGET_VERSION_ID, TEMPLATE_ID — status and versioning attributes.
• AMOUNT_TYPE — from IR.REFERENCE_9.
• CONSOLIDATED_AMOUNT — the amount imported through consolidation, divided by the factor.
• ENTERED_PERIOD_TO_DATE, ENTERED_QUARTER_TO_DATE, ENTERED_YEAR_TO_DATE, ENTERED_PROJECT_TO_DATE — the four entered balance measures, each computed from the corresponding GL_BALANCES quantities plus period net activity.
• ROW_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY — audit columns inherited from GL_BALANCES.

Common Use Cases and Queries

This view is typically queried during consolidation reconciliation and quarter-close reporting, for example to reconcile consolidated amounts against entered quarter-to-date balances per code combination:

• Retrieving entered quarter-to-date balances for a consolidation run: SELECT LEDGER_ID, CODE_COMBINATION_ID, PERIOD_NAME, ENTERED_QUARTER_TO_DATE FROM GL_JE_CONS_BALANCES_V WHERE CONSOLIDATION_ID = :p_consolidation_id;
• Comparing consolidated amounts against the corresponding entered balances to detect translation or rounding variances.
• Listing all balance measures per period: selecting ENTERED_PERIOD_TO_DATE, ENTERED_QUARTER_TO_DATE, ENTERED_YEAR_TO_DATE, and ENTERED_PROJECT_TO_DATE together for a given code combination.

Because the view joins through GL_IMPORT_REFERENCES, it returns only balance rows that have an associated consolidation import reference, making it suitable for consolidation-specific rather than general ledger inquiries.