Oracle R12- Bank Setup : Changes from 11i to R12

In R12 , bank setup has been moved from AP CE module, yes you should use a Cash Management responsibility with all grants and permissions to create and maintain bank accounts. The grants must be done by Sysadmins in User management responsibility.

The new tables are now under Cash Management product as follows:

CE_BANK_ACCOUNTS: contains Legal Entity Level bank account information. Each bank account must be affiliated with one bank branch.

CE_BANK_ACCT_USES_ALL: stores Operating Unit level bank account use information

CE_PAYMENT_DOCUMENTS: Payment Documents to be used for Printed type Payments

CE_BANK_BRANCHES_V: view: Bank/Branches Info
CE_BANK_ACCT_USES_OU_V: view: Internal Bank Account Uses Info

The following tables were obsoleted:

AP_BANK_BRANCHES
AP_BANK_ACCOUNTS_ALL
AP_BANK_ACCOUNTS_USES_ALL

In R12, Internal bank accounts are now created in Cash Management (Setup -> Banks

In R12, Supplier (or External) bank accounts are created in Payables, in the Supplier Entry forms.  In the Payables Manager responsibility:

1. Navigate to Suppliers -> Entry.
2. Query or create your supplier.
3. Click on Banking Details and then choose Create.

After you have created the bank account, you can assign the bank account to the supplier site.

Where is Supplier Bank Information Stored in Release 12?

In Release 12, Payables Supplier Bank Information is stored somewhere else instead of PO_VENDORS table as in 11i.

The supplier bank account information is in the table: IBY_EXT_BANK_ACCOUNTS, the bank and bank branches information is in the table: HZ_PARTIES.

The bank branch number can be found in the table: HZ_ORGANIZATION_PROFILES

The HZ_ORGANIZATION_PROFILES table stores a variety of information about a party. This table gets populated when a party of the Organization type is created. This table also contains data retrieved from Dun & Bradstreet using either the Dun & Bradstreet online or batch download methods. Historical data for the organization can also be stored in this table. Each time organization information is changed, the effective end date column for the original record is updated and a new record that contains the updated information is created.

The column name is BANK_OR_BRANCH_NUMBER VARCHAR2 (30) Stores bank number for banks and branch number for bank branches, primarily ABA number for US bank branches.