Search Results gl_daily_balances




Overview
Explore in AI Chat

Overview

The GL_DAILY_BALANCES table is a core data repository within the Oracle E-Business Suite General Ledger (GL) module. It serves as the primary storage location for daily aggregated account balances, forming the foundation for financial reporting and analysis. Its role is critical for maintaining a granular, day-level view of financial activity for both detail and summary accounting flexfield combinations. This table is populated during the posting process and is essential for generating accurate trial balances, income statements, and balance sheets at any point within an accounting period, enabling real-time financial insight.

Key Information Stored

The table stores aggregated financial data keyed by several dimensions. The primary key (GL_DAILY_BALANCES_PK) uniquely identifies a balance record through a combination of the LEDGER_ID, CODE_COMBINATION_ID, CURRENCY_CODE, CURRENCY_TYPE, ACTUAL_FLAG, PERIOD_NAME, and CONVERTED_FROM_CURRENCY. Key columns include CODE_COMBINATION_ID, which links to the specific account; PERIOD_NAME for the accounting period; and CURRENCY_CODE for the transaction currency. The ACTUAL_FLAG distinguishes between actual ('A') and budget data. The table holds aggregated balance figures, typically including beginning balance, period activity, and ending balance for each day, though the specific amount columns (e.g., BEGIN_BALANCE_DR, PERIOD_NET_DR) are implied by the table's purpose and standard GL conventions.

Common Use Cases and Queries

This table is central to daily and period-end financial reporting. A common use case is generating a daily trial balance for a specific ledger. A typical query pattern involves joining to GL_CODE_COMBINATIONS and GL_LEDGERS to retrieve account and ledger details, filtering by LEDGER_ID, PERIOD_NAME, and ACTUAL_FLAG. For currency reporting, queries often filter on CURRENCY_CODE or CURRENCY_TYPE. Performance analysts may query this table to track daily revenue or expense accruals. Sample SQL to retrieve daily ending balances for a period would select from GL_DAILY_BALANCES GDB, joining GL_CODE_COMBINATIONS GCC on GDB.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID, with WHERE clauses for GDB.LEDGER_ID, GDB.PERIOD_NAME, and GDB.ACTUAL_FLAG = 'A'.

Related Objects

The GL_DAILY_BALANCES table maintains defined foreign key relationships with several other EBS objects, ensuring referential integrity. As per the provided metadata, key relationships include:

  • GL_CODE_COMBINATIONS: Joined via CODE_COMBINATION_ID to retrieve account segment values and descriptive information.
  • GL_PERIOD_TYPES: Joined via PERIOD_TYPE to validate the accounting period type.
  • GL_SUMMARY_TEMPLATES: Joined via TEMPLATE_ID for accounts using summary templates.
  • GL_LEDGERS: Joined via LEDGER_ID to identify the specific ledger context.
  • FND_CURRENCIES: Joined via CURRENCY_CODE to obtain currency details and precision.
These relationships are fundamental for constructing complete financial reports that combine transactional balances with descriptive master data.