Search Results xtr_bank_accounts

Overview

The XTR_BANK_ACCOUNTS table is a core data object within the Oracle E-Business Suite Treasury (XTR) module, serving as the central repository for bank account master data. It stores the fundamental configuration and relationship information for bank accounts utilized in treasury operations across versions 12.1.1 and 12.2.2. This table is pivotal for linking financial instruments, cash management structures, and party information to specific bank accounts, enabling the processing and settlement of deals, cash pooling, and balance tracking. Its integrity is enforced by a primary key and numerous foreign key relationships, underscoring its critical role as a reference point for transactional data throughout the Treasury application.

Key Information Stored

The table's primary key is a composite of ACCOUNT_NUMBER and PARTY_CODE, uniquely identifying each account record. Key columns include ACCOUNT_NUMBER for the bank account identifier and PARTY_CODE, which links to XTR_PARTY_INFO to identify the account holder. Critical relational columns are BANK_BRANCH_ID and BANK_ACCT_USE_ID, which reference HZ_PARTIES to store TCA (Trading Community Architecture) party IDs for the bank branch and the specific account usage, respectively. The CURRENCY column references XTR_MASTER_CURRENCIES. For accounting integration, CODE_COMBINATION_ID, PARTY_INT_CCID, and PARTY_PRIN_CCID all reference GL_CODE_COMBINATIONS to define the General Ledger accounts for the bank account balance, interest, and principal. The CASHPOOL_ID column links to CE_CASHPOOLS for cash management integration.

Common Use Cases and Queries

Primary use cases involve treasury deal processing, bank balance reporting, and account reconciliation. A common reporting requirement is to list all bank accounts with their associated GL accounts and currency for a given company or party. A sample query for such a report would join XTR_BANK_ACCOUNTS with XTR_PARTY_INFO and GL_CODE_COMBINATIONS. Another critical operational query involves validating accounts used in deal settlements by joining XTR_DEALS on columns like SETTLE_ACCOUNT_NO or MATURITY_ACCOUNT_NO to XTR_BANK_ACCOUNTS to ensure account validity and retrieve associated GL codes for posting. Technical support often queries this table to troubleshoot issues with bank account setup or to verify foreign key relationships when processing interfaces from external cash management systems into XTR_BANK_BAL_INTERFACE.

Related Objects

As indicated by the extensive foreign key metadata, XTR_BANK_ACCOUNTS is a hub table with dependencies across the Treasury module. It is directly referenced by major transactional tables including XTR_DEALS (for buy, sell, maturity, premium, settlement, and start accounts), XTR_DEAL_DATE_AMOUNTS, and XTR_INTEREST_RATE_RANGES. Balance-related tables XTR_BANK_BALANCES and XTR_BANK_BAL_INTERFACE use it as a parent table. For master data, it references XTR_PARTY_INFO, XTR_MASTER_CURRENCIES, and the application's core tables HZ_PARTIES and GL_CODE_COMBINATIONS. Its relationship with CE_CASHPOOLS provides integration with the Cash Management module, while XTR_SOURCE_OF_IMPORTS uses it to define accounts for data import sources.