Search Results xtr_bank_balances




Overview
Explore in AI Chat

Overview

The XTR_BANK_BALANCES table is a core data object within the Oracle E-Business Suite Treasury (XTR) module for versions 12.1.1 and 12.2.2. It serves as the central repository for storing daily bank balance information, a critical component for cash positioning, liquidity management, and bank reconciliation processes. The table's primary role is to maintain a historical and current record of the ending balance for each configured bank account on a per-day basis. This granular data is essential for generating accurate treasury reports, forecasting cash flow, and ensuring alignment between the company's internal ledger and external bank statements.

Key Information Stored

The table's structure is defined by its composite primary key, which uniquely identifies a balance record through the combination of COMPANY_CODE, ACCOUNT_NUMBER, and BALANCE_DATE. This design enforces a single daily balance entry per account. Key columns include the BALANCE_DATE, which stores the calendar date for the balance, and the ACCOUNT_NUMBER, identifying the specific bank account. The COMPANY_CODE links the account to the owning legal entity. The table also holds the actual BALANCE amount for the specified date. Furthermore, it integrates with the transaction processing system via the FIRST_BATCH_ID and LAST_BATCH_ID columns, which can link to the XTR_BATCHES table to identify the range of treasury transactions included in that day's closing balance. The BANK_ACCT_USE_ID column provides a critical integration point with the Cash Management (CE) module by linking to the CE_BANK_ACCT_USES_ALL table.

Common Use Cases and Queries

A primary use case is the generation of daily cash position reports, which aggregate balances across multiple accounts and companies. Treasury analysts frequently query this table to analyze balance trends over time for a specific account or to reconcile internal records against bank statements. A common reporting pattern involves joining to the XTR_BANK_ACCOUNTS table to retrieve descriptive account information. For example, a query to retrieve the last 30 days of balances for a specific account would filter on ACCOUNT_NUMBER and a BALANCE_DATE range. Another critical scenario is the month-end close process, where the final balance for the period is extracted and validated. The integration via BANK_ACCT_USE_ID allows for consolidated reporting that combines detailed treasury transaction data with broader Cash Management bank account structures.

Related Objects

The XTR_BANK_BALANCES table maintains documented foreign key relationships with several key objects, establishing its place in the data model.

  • XTR_BANK_ACCOUNTS: Linked via COMPANY_CODE and ACCOUNT_NUMBER. This is the master table for treasury bank account definitions.
  • XTR_BATCHES (twice): Linked via FIRST_BATCH_ID and LAST_BATCH_ID to different rows in the batches table. This connects the balance snapshot to the specific sets of transactions that were processed to calculate it.
  • CE_BANK_ACCT_USES_ALL: Linked via BANK_ACCT_USE_ID. This relationship integrates the treasury-specific balance record with the shared Cash Management bank account model, enabling enterprise-wide cash reporting.