Search Results iby_bankacct




Overview
Explore in AI Chat

Overview

The IBY_BANKACCT table is a core data object within the Oracle E-Business Suite (EBS) Payments (IBY) module. It serves as the central repository for storing detailed bank account information for both payers (customers) and payees (suppliers, employees, etc.). This table is fundamental to the payment execution process, enabling the system to correctly route electronic funds transfers (EFT), print checks with accurate account details, and manage all forms of disbursements and receipts. Its integrity is critical for ensuring payments reach their intended financial institutions and accounts.

Key Information Stored

The table's primary key is the INSTRID (Instrument ID), which uniquely identifies each bank account record. Key columns and their purposes include: INSTRID for the unique identifier; BANK_ID to link to the financial institution in the CE_BANKS table; BANK_ACCOUNT_NUM for the account number; BANK_ACCOUNT_NAME for the account holder's name; and CURRENCY_CODE for the account's currency. Crucially, it holds foreign key relationships to other master data tables: ACCTTYPEID links to IBY_ACCTTYPE to define the account type (e.g., Checking, Savings), and ADDRESSID links to HZ_LOCATIONS to store the associated address for the account, which is often required for payment processing compliance.

Common Use Cases and Queries

A primary use case is retrieving bank account details for a specific payee to generate a payment instruction. For example, when processing an invoice payment, the system joins IBY_BANKACCT to supplier or customer data via the IBY_INSTRHOLDER table. Common reporting and validation queries include listing all active bank accounts for a given party or verifying account details before a payment batch submission. A typical SQL pattern to fetch payee bank information would join through the instrument holder relationship:

  • SELECT ba.BANK_ACCOUNT_NUM, ba.BANK_ACCOUNT_NAME, at.ACCOUNT_TYPE_NAME FROM IBY_BANKACCT ba, IBY_INSTRHOLDER ih, IBY_ACCTTYPE at WHERE ba.INSTRID = ih.INSTRID AND ba.ACCTTYPEID = at.ACCTTYPEID AND ih.INSTRHOLDER_ID = :party_id;

Related Objects

IBY_BANKACCT is centrally connected to several other key EBS objects. The IBY_INSTRHOLDER table acts as a mapping table, linking the bank account (INSTRID) to the specific customer or supplier party. It has a direct foreign key dependency on the HZ_LOCATIONS table for address data and on the IBY_ACCTTYPE table for account type definitions. For bank master information (bank name, branch), it typically relates to the CE_BANKS and CE_BANK_BRANCHES tables via the BANK_ID. This network of relationships integrates payment instructions with the broader Trading Community Architecture (TCA) and Cash Management foundations of Oracle EBS.

  • Table: IBY_BANKACCT 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_BANKACCT,  object_name:IBY_BANKACCT,  status:VALID,  product: IBY - Payments ,  description: IBY_BANKACCOUNTstores bank account related information of the customer(payer) or payee. ,  implementation_dba_data: IBY.IBY_BANKACCT , 

  • Table: IBY_BANKACCT 12.1.1

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_BANKACCT,  object_name:IBY_BANKACCT,  status:VALID,  product: IBY - Payments ,  description: IBY_BANKACCOUNTstores bank account related information of the customer(payer) or payee. ,  implementation_dba_data: IBY.IBY_BANKACCT , 

  • Table: IBY_INSTRHOLDER 12.1.1

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_INSTRHOLDER,  object_name:IBY_INSTRHOLDER,  status:VALID,  product: IBY - Payments ,  description: IBY_INSTRHOLDER stores the information about the holder of the instrment. A payment instrument can be held by different users or payees or payers. ,  implementation_dba_data: IBY.IBY_INSTRHOLDER , 

  • View: IBY_BANKACCT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IBY.IBY_BANKACCT_V,  object_name:IBY_BANKACCT_V,  status:VALID,  product: IBY - Payments ,  description: View used to work with registered bank accounts. ,  implementation_dba_data: APPS.IBY_BANKACCT_V , 

  • Table: IBY_INSTRHOLDER 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_INSTRHOLDER,  object_name:IBY_INSTRHOLDER,  status:VALID,  product: IBY - Payments ,  description: IBY_INSTRHOLDER stores the information about the holder of the instrment. A payment instrument can be held by different users or payees or payers. ,  implementation_dba_data: IBY.IBY_INSTRHOLDER , 

  • Table: IBY_ACCTTYPE 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_ACCTTYPE,  object_name:IBY_ACCTTYPE,  status:VALID,  product: IBY - Payments ,  description: IBY_ACCTTYPE contains a list of various account types supported. For example for bank account, the account types could be Checking, Savings etc, for Credit Card, the account types could be Visa, MasterCard, Discover etc... ,  implementation_dba_data: IBY.IBY_ACCTTYPE , 

  • Table: IBY_ACCTTYPE 12.1.1

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_ACCTTYPE,  object_name:IBY_ACCTTYPE,  status:VALID,  product: IBY - Payments ,  description: IBY_ACCTTYPE contains a list of various account types supported. For example for bank account, the account types could be Checking, Savings etc, for Credit Card, the account types could be Visa, MasterCard, Discover etc... ,  implementation_dba_data: IBY.IBY_ACCTTYPE , 

  • View: IBY_BANKACCT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:IBY.IBY_BANKACCT_V,  object_name:IBY_BANKACCT_V,  status:VALID,  product: IBY - Payments ,  description: View used to work with registered bank accounts. ,  implementation_dba_data: APPS.IBY_BANKACCT_V , 

  • View: IBY_TRANS_BANKACCT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:IBY.IBY_TRANS_BANKACCT_V,  object_name:IBY_TRANS_BANKACCT_V,  status:VALID,  product: IBY - Payments ,  implementation_dba_data: APPS.IBY_TRANS_BANKACCT_V , 

  • View: IBY_TRANS_BANKACCT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IBY.IBY_TRANS_BANKACCT_V,  object_name:IBY_TRANS_BANKACCT_V,  status:VALID,  product: IBY - Payments ,  implementation_dba_data: APPS.IBY_TRANS_BANKACCT_V ,