External Bank Account Tables in Oracle Apps R12 - Orapoint

We’ll talk about Oracle Banks tables in this article. We store two sorts of banks in Oracle applications. Internal and external banks are two types of financial institutions. Internal banks are banks that we build in Oracle applications to process payments to vendors and receive payments from customers. Bank tables in Oracle Apps R12 store information about banks, branches, and bank accounts. The following is a complete list of Oracle Apps r12 Bank tables.

Types of Bank Account in Oracle Apps R12

1. Internal Bank Account
2. External Bank Account

Internal Bank Account

Internal Banks are Oracle’s internal banks, also known as business unit or organization internal banks, which are used to pay customer invoices and receive payments from customers. following are the internal bank tables.

• CE_BANK_ACCOUNTS: This Includes bank account information at the legal entity level. Every bank account must be linked to a single bank branch.
• CE_BANK_ACCT_USES_ALL: This provides information on bank account usage at the Operating Unit level.
• CE_BANKS_V: This is a view and this provides information with basic bank account columns.

External Bank Account

External Banks are those that have a relationship with our or our organization’s customers and suppliers. Because both customers and suppliers are external entities, Oracle has separated the banking information for both entities into different tables than the internal banks. Following are the external bank tables.

• IBY_EXTERNAL_PAYERS_ALL: This table holds payment-related attributes for external party payers during the funds capture procedure. This table maintains the information entered on the client account setup UI’s payment details (header) screen.
• IBY_PMT_INSTR_USES_ALL: This table contains a reference to the Site/Supplier to which the Bank Account has been assigned.
• IBY_EXT_BANK_ACCOUNTS: Oracle uses this table to keep track of external bank account numbers (like Bank account details of a supplier to remit the money in).

In Oracle applications, there are a few important SQL queries for banks.

SELECT 	B.BANK_NAME
FROM 	CE_BANK_ACCOUNTS A ,
		CE_BANKS_V B
WHERE 	A.BANK_ACCOUNT_ID 
		IN (SELECT B.BANK_ACCOUNT_ID
			FROM CE_BANK_ACCT_USES_ALL B
			WHERE 1=1
			AND (NVL(AP_USE_ENABLE_FLAG,'N' ) = 'Y' OR NVL(AR_USE_ENABLE_FLAG,'N' ) = 'Y' ))
	AND B.BANK_PARTY_ID =A.BANK_ID
ORDER BY A.BANK_ACCOUNT_NAME;