Search Results gl_balances_delta




Overview
Explore in AI Chat

Overview

GL_BALANCES_DELTA is a General Ledger (GL) table in the Oracle E-Business Suite schema (owner GL) that stores incremental changes to account balances. Where GL_BALANCES holds the authoritative, posted, cumulative balances for each account combination and period, GL_BALANCES_DELTA captures the "delta" (net change) records used to reconcile or propagate balance movement between runs or summary processes. It is a standard 12.1.1 / 12.2.2 object and is listed as VALID in the ETRM data dictionary.

From a Data Vault modeling perspective, the metadata heuristic classifies this object as a link. This is consistent with its foreign-key profile: each row binds a ledger, an account combination, a currency, and (optionally) a budget version, encumbrance type, and summary template into a single association. It is best treated as a transaction-style link carrying descriptive measures rather than as an independent hub.

Key Information Stored

The table contains 29 documented columns. The most significant are:

No single documented column is flagged as a surrogate primary key; the business-key candidate is the composite of DELTA_RUN_ID, LEDGER_ID, CODE_COMBINATION_ID, CURRENCY_CODE, PERIOD_NAME, and ACTUAL_FLAG (with BUDGET_VERSION_ID/ENCUMBRANCE_TYPE_ID where applicable).

Common Use Cases and Queries

Typical uses include incremental balance reconciliation, delta-based reporting between GL_BALANCES snapshots, and verification of summary-template rollups. A representative query joins the delta rows to their parent account combinations:

  • Reconcile a delta run: SELECT d.CODE_COMBINATION_ID, d.PERIOD_NAME, d.PERIOD_NET_DR, d.PERIOD_NET_CR FROM GL_BALANCES_DELTA d WHERE d.DELTA_RUN_ID = :run_id;
  • Resolve account detail: SELECT d.*, c.CONCATENATED_SEGMENTS FROM GL_BALANCES_DELTA d, GL_CODE_COMBINATIONS c WHERE d.CODE_COMBINATION_ID = c.CODE_COMBINATION_ID;
  • Filter by ledger and period range for a specific actual/budget/encumbrance flag and currency.

Related Objects

  • GL_BALANCES — the primary balance table whose deltas this object mirrors.
  • GL_CODE_COMBINATIONS — joined via CODE_COMBINATION_ID for account segments.
  • GL_SETS_OF_BOOKS_11I (GL_LEDGERS) — joined via LEDGER_ID.
  • FND_CURRENCIES — joined via CURRENCY_CODE.
  • GL_BUDGET_VERSIONS — joined via BUDGET_VERSION_ID.
  • GL_ENCUMBRANCE_TYPES — joined via ENCUMBRANCE_TYPE_ID.
  • GL_SUMMARY_TEMPLATES — joined via TEMPLATE_ID.

Standard GL concurrent programs (such as balance summary and reconciliation processes) and the GL_BALANCES_DELTA-driven delta interfaces are the principal consumers of this table.