Search Results intermediary_acct_id

Overview

The IBY_INTERMEDIARY_ACCTS table is a core data object within the Oracle E-Business Suite (EBS) Payments module (IBY). It serves the critical function of storing detailed information for intermediary bank accounts. In the context of global payment processing, an intermediary bank is a third-party financial institution that facilitates the transfer of funds between the originating and beneficiary banks, particularly in cross-border transactions. This table enables the system to define and manage the specific account details at these intermediary institutions, which are essential for generating accurate payment instructions, such as SWIFT MT103 messages, ensuring funds are routed correctly through the banking network.

Key Information Stored

The table's primary purpose is to link a specific intermediary bank account to a payer's or payee's bank account. Its structure is defined by key columns that establish these relationships and hold the necessary account details. The primary key, INTERMEDIARY_ACCT_ID, uniquely identifies each record. Two critical foreign key columns create the essential links to other banking master data: BANK_ACCT_ID references IBY_EXT_BANK_ACCOUNTS to associate the intermediary account with an external (customer or supplier) bank account, while INTERNAL_BANK_ACCOUNT_ID references CE_BANK_ACCOUNTS to associate it with an internal company bank account. Additional columns typically store the specific account number, bank identifier (like a SWIFT BIC), and other routing information required by the intermediary institution.

Common Use Cases and Queries

This table is primarily accessed during the payment instruction generation process within Payables or Receivables. A common operational query involves retrieving the intermediary account details for a specific external bank account to populate a payment file. For example: SELECT * FROM iby_intermediary_accts WHERE bank_acct_id = <external_bank_account_id>;. Reporting and reconciliation use cases include listing all internal bank accounts configured with a specific intermediary bank or validating setup completeness. Administrators may run queries to audit configurations, ensuring that intermediary accounts are correctly assigned for relevant currencies or countries where cross-border payments are frequent.

Related Objects

The IBY_INTERMEDIARY_ACCTS table is centrally connected to the EBS banking architecture. Its two primary foreign key relationships are fundamental:

• IBY_EXT_BANK_ACCOUNTS: This table stores bank accounts for trading partners (suppliers, customers, employees). The link via BANK_ACCT_ID allows an intermediary account to be assigned to a specific payee or payer account for outgoing or incoming payments.
• CE_BANK_ACCOUNTS: This table stores the organization's internal bank accounts. The link via INTERNAL_BANK_ACCOUNT_ID allows an intermediary account to be assigned to a specific company bank account from which payments are originated.

This table is also referenced by various payment formatting engines and APIs within the IBY module that construct payment messages requiring intermediary routing instructions.