Search Results ar_payments_interface_all

Overview

The IBY_EXT_BANK_ACCOUNTS table is a core data repository within the Oracle Payments (IBY) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the master table for storing detailed information about external bank accounts, which are accounts held by business partners such as suppliers and customers. These accounts are manually entered into the system, typically via the Banking Details page associated with a trading partner's record. The table's primary role is to centralize and secure the sensitive banking information required to execute electronic payments and process receipts, forming a critical link between the EBS financial modules and the external banking infrastructure.

Key Information Stored

The table stores comprehensive details for each external bank account. The primary key is the EXT_BANK_ACCOUNT_ID, which uniquely identifies each account record. As indicated by the metadata, a significant aspect of the table's design is its focus on security and data protection for sensitive fields. It achieves this through relationships with the IBY_SECURITY_SEGMENTS table via foreign keys for different account number formats: BA_NUM_SEC_SEGMENT_ID for basic bank account numbers, IBAN_SEC_SEGMENT_ID for International Bank Account Numbers, and BA_NUM_ELEC_SEC_SEGMENT_ID for electronic account numbers. This structure facilitates the masking and encryption of account details. While the specific column list is not fully detailed in the excerpt, typical data stored includes bank and branch identifiers, account holder name, currency, and the various secured account number segments.

Common Use Cases and Queries

The primary use case is the management and retrieval of bank account details for payment and receipt processing. When generating a payment batch to suppliers, the system queries this table to obtain the correct destination account. Similarly, when recording customer receipts via AutoLockbox, the system references this table to match incoming transactions to the correct customer account. Common reporting needs include listing all bank accounts for a specific supplier or customer, or identifying accounts for a particular bank and currency. A fundamental query pattern involves joining with trading partner tables (e.g., AP_SUPPLIERS, HZ_PARTIES) and the security segments table to retrieve a decrypted or masked account number for verification purposes.

Related Objects

The IBY_EXT_BANK_ACCOUNTS table is central to the Payments data model, with numerous key relationships. As per the provided metadata, it is referenced by several important tables. The IBY_ACCOUNT_OWNERS table links external bank accounts to their owning parties (suppliers, customers, etc.). For receipts processing, it is referenced by AR_CASH_RECEIPTS_ALL, AR_INTERIM_CASH_RECEIPTS_ALL, and AR_PAYMENTS_INTERFACE_ALL via the CUSTOMER_BANK_ACCOUNT_ID column. The IBY_INTERMEDIARY_ACCTS table references it for complex payment routing. For security, it has foreign key dependencies to the IBY_SECURITY_SEGMENTS table, as previously noted. This network of relationships underscores its critical role as the authoritative source for external banking data across the Oracle EBS suite.