Results for “jl_co_gl_balances”

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

Overview

The JL_CO_GL_BALANCES table is a Latin America Localizations (JL) object within Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented description identifies it as a "Third Party Balances Table Summarized By Third Party Identifier And Period For A Code Combination And Set Of Books ID." In practical terms, the table stores period-level balances aggregated by an external third party (identified through a national identifier, or NIT) rather than by a customer, supplier, or employee. It therefore supports Latin American legal and fiscal reporting requirements, such as country-specific bookkeeping and third-party balance declarations, that require balances to be organized by tax identification number (NIT) together with an accounting flexfield combination and a ledger.

Within the ETRM metadata, the heuristic Data Vault classification for this object is a link. This is a modeling suggestion derived from the foreign key structure: the table associates three distinct business entities — a third party (JL_CO_GL_NITS), an accounting code combination (GL_CODE_COMBINATIONS), and a set of books (GL_SETS_OF_BOOKS_11I) — across a defined period. Treating it as a link table is consistent with its role as a connector between those hubs and its period-qualified uniqueness constraints.

Key Information Stored

The table is physically owned by the JL schema and contains 18 documented columns. The most significant are summarized below.

• BALANCE_ID — the surrogate primary key, defined by the JL_CO_GL_BALANCES_PK constraint. It provides a stable, system-generated identifier for each balance row.
• NIT_ID — the third-party identifier, referencing JL_CO_GL_NITS. This is the core business reference that distinguishes the localization-specific summary from standard general ledger balances.
• CODE_COMBINATION_ID — references GL_CODE_COMBINATIONS, tying each balance to a specific accounting flexfield combination.
• SET_OF_BOOKS_ID — references GL_SETS_OF_BOOKS_11I, scoping the balance to a ledger.
• PERIOD_NAME, PERIOD_NUM, PERIOD_YEAR — the accounting period attributes under which the balance is summarized.
• CURRENCY_CODE — the currency in which the stored balances are denominated.
• ACCOUNT_CODE — the account-level code associated with the summarized balance.
• BEGIN_BALANCE_DR and BEGIN_BALANCE_CR — opening debit and credit balances for the period.
• PERIOD_NET_DR and PERIOD_NET_CR — period net debit and credit activity.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit and who-columns.

The business-key candidate is defined by the unique index JL_CO_GL_BALANCES_U1 on the combination of NIT_ID, CODE_COMBINATION_ID, PERIOD_NAME, and SET_OF_BOOKS_ID. This confirms that a single row represents one third party's balance for one code combination in one period within one set of books.

Common Use Cases and Queries

Typical reporting scenarios retrieve period-aware, NIT-level balances. A representative query joining the primary key and business keys is:

• Reconciling localization balances to the underlying general ledger by joining CODE_COMBINATION_ID and SET_OF_BOOKS_ID against GL tables for a given PERIOD_NAME.
• Producing statutory third-party balance statements by grouping on NIT_ID and PERIOD_NAME, using BEGIN_BALANCE_DR/CR and PERIOD_NET_DR/CR.
• Comparing opening versus net movement for a currency by filtering on CURRENCY_CODE and PERIOD_YEAR.
• Auditing who created or changed balances by querying the CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE columns.
• Detecting duplicate or missing business keys by scanning against JL_CO_GL_BALANCES_U1.

Related Objects

Foreign key metadata establishes the principal relationships for this table:

• JL_CO_GL_NITS — joined on NIT_ID; holds the third-party identifier master data.
• GL_CODE_COMBINATIONS — joined on CODE_COMBINATION_ID; provides the account combination definition.
• GL_SETS_OF_BOOKS_11I — joined on SET_OF_BOOKS_ID; supplies ledger context.
• JL_CO_GL_BALANCES_PK — the primary key constraint on BALANCE_ID.
• JL_CO_GL_BALANCES_U1 — the unique index enforcing the NIT_ID, CODE_COMBINATION_ID, PERIOD_NAME, and SET_OF_BOOKS_ID business key.

These relationships define the object's role as a link between third-party, accounting, and ledger hubs across defined periods within the JL localization.