Search Results ce_bank_acct_balances

Overview

The CE_BANK_ACCT_BALANCES table is a core data repository within the Oracle E-Business Suite Cash Management (CE) module, specifically for versions 12.1.1 and 12.2.2. Its primary role is to store the internal ledger for bank account balances. This table functions as the system of record for the financial position of each internal bank account defined within the application, enabling reconciliation, cash positioning, and forecasting. It is distinct from transactional tables, as it holds the calculated balance results that are critical for treasury operations and financial reporting.

Key Information Stored

The table's structure is designed to track balances over time and by type. The primary key, BANK_ACCT_BALANCE_ID, uniquely identifies each balance record. The most critical foreign key is BANK_ACCOUNT_ID, which links to the CE_BANK_ACCOUNTS table, thereby associating every balance with a specific bank account. While the provided ETRM excerpt does not list all columns, typical and essential columns in this table include balance dates (e.g., BALANCE_DATE), balance types (e.g., LEDGER_BALANCE, AVAILABLE_BALANCE, VALUE_DATED_BALANCE), and the corresponding currency amounts. It also commonly includes columns for the source of the balance data, such as whether it was manually entered, imported from a bank statement, or derived from system transactions.

Common Use Cases and Queries

The primary use case is generating cash position and liquidity reports by querying the latest available or ledger balances for a set of bank accounts. Finance teams use this data for daily cash management and short-term investing or borrowing decisions. A common query pattern involves joining to CE_BANK_ACCOUNTS and related tables to retrieve balances with descriptive account and bank details.

• Sample SQL Pattern for Current Balances: SELECT cba.bank_account_name, cbab.balance_date, cbab.available_balance FROM ce_bank_acct_balances cbab, ce_bank_accounts cba WHERE cbab.bank_account_id = cba.bank_account_id AND cbab.balance_date = (SELECT MAX(balance_date) FROM ce_bank_acct_balances WHERE bank_account_id = cbab.bank_account_id);
• Another critical use is reconciling the internal CE_BANK_ACCT_BALANCES ledger against external bank statements or the general ledger (GL), often facilitated by custom or standard reports.

Related Objects

As indicated by the foreign key metadata, this table has a direct and essential relationship with the CE_BANK_ACCOUNTS table (CE_BANK_ACCT_BALANCES.BANK_ACCOUNT_ID). It is also intrinsically linked to the CE_STATEMENT_HEADERS table, as imported bank statement ending balances typically populate this balances table. For comprehensive reporting, queries often join to GL_CODE_COMBINATIONS (for the associated cash account) and CE_BANK_BRANCHES. Key APIs, such as those in the CE_BANK_ACCT_BAL_PKG, are used to create and update balance records programmatically, ensuring data integrity.