Results for “gl_variance_sec_balances_v”

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

Overview

GL_VARIANCE_SEC_BALANCES_V is a General Ledger (GL) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is a reporting-oriented view built on top of GL_BALANCES, joined to GL_LEDGERS, and it invokes the server-side package GLR03300_PKG to derive currency-type decisions and rounding/ factor adjustments. Its purpose is to present period-level debit and credit activity in a form suitable for variance and trend reporting, with separate measures for entered (transaction currency) and functional (ledger currency) amounts.

The view exposes amounts already aggregated to the period level rather than journal-level detail, which makes it attractive for dashboards, Financial Statement Generator (FSG)-style extracts, and custom reconciliations. Because it carries LEDGER_ID, PERIOD_NAME, CODE_COMBINATION_ID, ACTUAL_FLAG, BUDGET_VERSION_ID, ENCUMBRANCE_TYPE_ID, and CURRENCY_CODE, it can be sliced across ledger, accounting period, account combination, actual/budget, and currency dimensions. The TRANSLATED_FLAG and TEMPLATE_ID columns support translated and recurring journal variants.

Underlying Base Objects

The documented base objects for this view are:

• GL_BALANCES (synonym) — the primary source, aliased as BA. Provides ledger, period, currency, code combination, actual/budget flags, encumbrance and budget version identifiers, the PERIOD_NET_DR/PERIOD_NET_CR families, and the _BEQ (beginning-equivalent) variants.
• GL_LEDGERS (synonym) — aliased as LED, supplying the ledger currency used to determine whether a row is already in the ledger's own currency. The DECODE on BA.CURRENCY_CODE = LED.CURRENCY_CODE drives whether the _BEQ columns or the standard columns are selected.
• GLR03300_PKG (package) — a PL/SQL package invoked twice per expression: GET_CURRENCY_TYPE returns 'E' for entered-currency-sensitive accounting and GET_FACTOR supplies a divisor used to normalize amounts. These are session-context-driven calls.

Row identity is preserved through BA.ROWID exposed as ROW_ID.

Key Columns

• LEDGER_ID, PERIOD_NAME, PERIOD_YEAR, PERIOD_NUM — the accounting period key.
• CODE_COMBINATION_ID — the accounting flexfield combination. All amount columns return NULL when this is null.
• CURRENCY_CODE — transaction currency of the balance row.
• ACTUAL_FLAG, BUDGET_VERSION_ID, ENCUMBRANCE_TYPE_ID — distinguish actuals from budget and encumbrance balances.
• ENTERED_PERIOD_NET_DR / ENTERED_PERIOD_NET_CR — period activity in entered currency, with _BEQ handling per GET_CURRENCY_TYPE.
• FUNCTIONAL_PERIOD_NET_DR / FUNCTIONAL_PERIOD_NET_CR — the functional (ledger-currency) equivalents. The user's search term FUNCTIONAL_PERIOD_NET_CR maps directly to this column: it resolves to NVL(PERIOD_NET_CR_BEQ,0)/GET_FACTOR when the row currency differs from the ledger currency, and is intentionally NULL for ledger-currency or statistical ('STAT') rows to prevent double-counting.

Additional quarter-to-date and year-to-date variants are derived from the corresponding _DR/_CR base columns.

Common Use Cases and Queries

Typical applications include functional-currency variance analysis, period-over-period credit-trend reporting, and feeder extracts for downstream ETL. A representative query isolating functional credits for a ledger and period:

• SELECT period_name, code_combination_id, currency_code, FUNCTIONAL_PERIOD_NET_CR FROM apps.gl_variance_sec_balances_v WHERE ledger_id = :ledger_id AND period_name = :period AND actual_flag = 'A';

Because FUNCTIONAL_PERIOD_NET_CR depends on GLR03300_PKG session context, the view should be queried from within an initialized GL session (or with the appropriate context set) so that GET_CURRENCY_TYPE and GET_FACTOR return meaningful values. Performance benefits from filtering on LEDGER_ID, PERIOD_NAME, and CODE_COMBINATION_ID, since those columns align with GL_BALANCES indexes.