- OracleApps Epicenter - http://www.oracleappshub.com -

R12 : EBS Banking Model in demanding and Changing World

Hey did you notice there is one thing that keep changing since last 2 releases ...the bank. We have seen there was once from pre 10.x to 11i when supplier bank separated from suppliers data and now its again in R12 when it become part of TCA.This time , because of changing business need and high demand of global partners working model. Not only your company is operating globally,your partner too operating global,then why not use them. In typical business cost model, if corporate office is using Citibank for payroll for USA operation then why not Citibank Singapore branch is used for payroll for Singapore if they are operating there. Sound bit low...why ..

As we aware the key message of R12 while release was .

so what , think globally and work globally is factor driving for the changes .This release have witness the great changes ever into the bank model. Now the bank accounts is attached to your legal entity level rather than Operating Unit in which current and existing versions Offers. This makes bank with strong capability to pay across operating units. More over its important to understand banks accounts can be shared by applications and can be designed for use by Payables, Receivables and Payroll.

What is new in R12 for Bank

These changes make easier and more reliable by

Take a looks of some of the releases

Release 10.6 character/10.7 NCA to 11i
How 10.x supplier banks are mapped to 11i

  • Bank Name
    po_vendor_sites.bank_number => ap_bank_branches.bank_name
    po_vendor_sites.bank_number => ap_bank_branches.bank_number
  • Bank Number
    po_vendor_sites.bank_num => ap_bank_branches.bank_num
    po_vendor_sites.bank_num => ap_bank_branches.bank_branch_name
  • Bank Account Name
    po_vendor_sites_all.bank_account_name => ap_bank_accounts_all.bank_account_name
  • Bank Account Number
    po_vendor_sites_all.bank_account_num => ap_bank_accounts_all.bank_account_num

Release 11i

These are tables which hold the bank details irrespective of supplier or internal banks.

  • ap_bank_branches
  • ap_bank_accounts_all

Comparing the 11i Vs R12

If we compare the bank with 11i vs R12, we can notice the bank was utilized into three different places , finance ,payroll and treasury, which requires altogether a different setup. It was one of the big issues with integration aspect, as significant problem was recognized once the Expense management and payroll uses same bank for the respective person.

There was a common question/confusion between the Integration Existence between Bank Data in Accounts Payable and Bank Data In Payroll ?

As discussed above , you know most of release of 11i family of oracle Application does not have integration between HR and AP for bank account data.

We have notice in 11i there was functionality in which Payables in which we will create an employee type supplier from HR data and it will contain name and address info but not bank information. The reason for this is that HR/Payroll does not store the bank information in a standard way that makes the integration possible.

So now r12 this was well taken care and integration is built. There are plans under way for all bank account data models in the various products to be consolidated in the new TCA architecture. The Cash Management team is working on this project. Payables and HR/Payroll are working so that the eventual idea will be that you can set up bank accounts in one place and then indicate the usage (pay, expense reimbursement, etc).

For understanding it is comparison between 11i and release 12 , where TCA community take cares of every things.

Release 12 , what is new than

Bank Accounts will be stored in a new table called CE_BANK_ACCOUNTS and will be located at a Bank Branch.

The new table which hold the bank information are as:

  1. CE_BANK_ACCOUNT:stores bank account attributes
  2. CE_BANK_ACCT_USES_ALL : This stores the bank account use attributes specific to Operating Unit (AR, AP) and Legal Entity (Treasury).
  3. CE_GL_ACCOUNTS_CCID :The accounting data pertaining to the bank account use will be stored in the table.

This new data model allows the bank and bank branch entities to be defined separately allowing users to establish a hierarchical relationship between them.

Missing link between Supplier And Supplier Banks?

You should know



Internal Bank Accounts & Supplier and Customer Bank Accounts in R12

Internal Bank Accounts
In Release 12, each internal bank account is assigned to a Legal Entity. Any or all operating units associated with that legal entity are permitted to use that bank account.
Supplier and Customer Bank Accounts
In Release 12 provides a centralized repository for suppliers’ and customers’ bank account and credit card information. All data is stored in one, secure place, providing shared service centers and collection departments consistent information that they need.

Any comment guys..

20 Comments (Open | Close)

20 Comments To "R12 : EBS Banking Model in demanding and Changing World"

#1 Comment By guru On September 12, 2007 @ 12:11 am


Its well written and to just let you know there are some grammatical errors. You are doing a great job.

Can you write an article on relation between set of books , legal entity’s and Operating units?


#2 Comment By Fred On September 12, 2007 @ 2:02 am


This is just the info I was looking for. Great compilation!

One question,
What about payroll integration?

How is the link between employees and bank stored?

#3 Comment By Gareth Roberts On September 20, 2007 @ 1:46 am

Hi Anand,
Great post! Are the ap_bank_accounts, branches and uses tables maintained as views similar to RA_CUSTOMERS to the TCA tables?

#4 Comment By Upendra On September 24, 2007 @ 7:43 am

Everything fine,

But, can you tell me where to define, Suppier’s & Vendor’s Bank Accounts apart from the Supplier creation form.

Thank you

#5 Comment By When we create Supplier it will not populate in HZ tables On September 27, 2007 @ 7:25 am

When a Supplier is created Record will be Inserted in HZ_PARTIES. When the Supplier Site is created Record will be Inserted in HZ_PARTY_SITES. When Address is created it will be stored in HZ_LOCATIONS

The above is wrong when you create it will not populate record in HZ tables …..

#6 Comment By laurent On September 30, 2007 @ 10:43 am


PO_VENDORS is now a view in R12.

It’s replaced in fact by AP_SUPPLIERS table.

#7 Comment By Eli On November 20, 2007 @ 11:13 am


Could you explain me how I can to link the bank account with the supplier.
I understood that when a supplier bank is created, the banking information is stored in IBY_EXT_BANK_ACCOUNTS and then it is updated in HZ_CODE_ASSIGNMENTS
(HZ_CODE_ASSIGNMENTS.owner_table_id = IBY_EXT_BANK_ACCOUNTS.branch_id)

I supposed that the IBY_EXT_BANK_ACCOUNTS table have a link field with the Supplier (vendor_id) but I didn’t find it.

#8 Comment By sanjit On November 25, 2007 @ 7:23 am

I have already explain in my mail.

#9 Pingback By R12 : Bank & Trading Community Architecture(TCA) On November 26, 2007 @ 5:03 pm

[…] [1] […]

#10 Comment By David Haimes On December 1, 2007 @ 5:48 pm

the other thing you can do in R12 is a bank transfer, if you move cash from one account to another then cash management will use the accounts in the Intercompany Accounts set up in AGIS to generate the corrcet intercompny accountng for the transfer. This is possible because the owning LE is now stamped on the bank account.

guru – I have a post on my blog discussing how LE, OU and Ledgers are related. See it at the link below


#11 Pingback By Release 12 : Legal Entity uptake On December 7, 2007 @ 9:02 am

[…] to David, who pointed out last week regarding Bank Uptake in LE side in reference to my old post. Check his post for further […]

#12 Comment By query to link vendors to bank accounts On June 30, 2008 @ 8:57 am

FROM ap_suppliers asup,
iby_external_payees_all iep,
iby_pmt_instr_uses_all ipiu,
iby_ext_bank_accounts ieba
WHERE asup.party_id = iep.payee_party_id
AND iep.ext_payee_id = ipiu.ext_pmt_party_id
AND ipiu.instrument_type = ‘BANKACCOUNT’
AND ipiu.instrument_id = ieba.ext_bank_account_id
AND — ieba.bank_account_num = ‘456373861325476’
asup.vendor_name = ‘Oracle XXX’

#13 Comment By Sanjit Anand On June 30, 2008 @ 7:58 pm

Thanks bhupinder sohal, for sharing this query.

#14 Comment By Sudharsana Reddy On July 8, 2008 @ 5:40 am

Thank You.. It has help me lot

#15 Comment By Sachin On September 26, 2008 @ 2:55 pm

Hi Anand,
Its a great document, very well compiled, but I believe you missed IBY_EXT_BANK_ACCOUNTS table for External Bank.

Please let me know if you feel I am wrong or there is any other reason for not mentioning this table here.

Thanks & Regards
Sachin Goel

#16 Comment By Sachin On September 26, 2008 @ 2:55 pm

Hi Anand,
Its a great document, very well compiled, but I believe you missed IBY_EXT_BANK_ACCOUNTS table for External Bank.

Please let me know if you feel I am wrong or there is any other reason for not mentioning this table here.

Thanks & Regards

#17 Comment By Sanjit Anand On September 28, 2008 @ 8:52 pm

that true, supplier bank which is not your house bank and there account information is in the table: IBY_EXT_BANK_ACCOUNTS
where as bank and bank branches information is in the table: HZ_PARTIES.

you can try this by:
(SELECT party_id
FROM hz_party_sites
WHERE party_site_name = ”))

#18 Comment By Sanjit Anand On September 28, 2008 @ 8:56 pm

When the user define a new bank account in the supplier form the information is stored in the IBY_EXT_BANK_ACCOUNTS.

The internal bank accounts are stored in the CE_BANK_ACCOUNT.

#19 Pingback By R12 Supplier Bank – Techno Functional Guide | OracleApps Epicenter On October 21, 2008 @ 7:31 am

[…] R12 : EBS Banking Model in demanding and Changing World […]

#20 Comment By Prashant On September 1, 2009 @ 6:58 am

Thnx for the document.
I am facing a problem where multiple operating units are sharing the same account.
Please tell me the workaround in oracle.
I am thinking to define duplicate bank account in different operating units with differnt cash and cash clearing account.
Please tell me is this solution a good one?
or please tell me any other workaround.