Search Results gl_balances




Overview
Explore in AI Chat

Overview

The GL_BALANCES table is the central repository for all financial account balances within Oracle E-Business Suite General Ledger. It stores the cumulative period-end balances for every accounting combination across all ledgers, periods, and currency types. Its primary role is to serve as the definitive source for financial reporting, inquiry, and consolidation. The table holds balances for both detail and summary accounts, enabling efficient roll-up and reporting at various levels of the account hierarchy. As a core transactional table, it is fundamental to the integrity of the GL module, directly supporting the generation of key financial statements like the Balance Sheet and Income Statement.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies a specific balance record. The key columns, as per the ETRM, are LEDGER_ID, CODE_COMBINATION_ID, CURRENCY_CODE, PERIOD_NAME, ACTUAL_FLAG, BUDGET_VERSION_ID, ENCUMBRANCE_TYPE_ID, and TRANSLATED_FLAG. This structure allows the system to store separate balances for Actual, Budget, and Encumbrance amounts. Critical data columns include PERIOD_NET_DR, PERIOD_NET_CR, BEGIN_BALANCE_DR, BEGIN_BALANCE_CR, and PERIOD_NET_DR_BEQ for foreign currency balances. The TEMPLATE_ID column links to summary templates for consolidated reporting, while the PERIOD_TYPE links to the accounting calendar.

Common Use Cases and Queries

This table is primarily queried for financial reporting and account analysis. A common use case is retrieving the period-end balance for a specific account and ledger. For example, to find the Actual balance for a given code combination in a specific period, a query would filter on ACTUAL_FLAG = 'A', BUDGET_VERSION_ID IS NULL, and ENCUMBRANCE_TYPE_ID IS NULL. Another frequent pattern is generating a trial balance by joining GL_BALANCES with GL_CODE_COMBINATIONS and GL_LEDGERS, summing the net period activity (PERIOD_NET_DR - PERIOD_NET_CR) plus the beginning balance. The table is also essential for reconciliation processes, budget versus actual reporting, and multi-currency translations.

Related Objects

GL_BALANCES has extensive relationships with other core GL objects, as indicated by its foreign keys. The most critical relationships are with GL_CODE_COMBINATIONS (via CODE_COMBINATION_ID) for account segment details and GL_LEDGERS (via LEDGER_ID). It references GL_BUDGET_VERSIONS for budget data and GL_ENCUMBRANCE_TYPES for encumbrance tracking. For period validation, it links to GL_PERIOD_STATUSES (implied by PERIOD_NAME and LEDGER_ID) and GL_PERIOD_TYPES. The table GL_SUMMARY_TEMPLATES is referenced for consolidated balances. Key APIs and views, such as GL_JE_LINES and the GL_BALANCES reporting views, depend on or interact with this base table to present and validate financial data.