Posted on September 10th, 2007 by Sanjit Anand || Email This Post
Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today |
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 .
- Think Globally – using business intelligence and analysis tools
- Work Globally – using the global capabilities of the applications
- Manage Globally – using the latest system architecture and middleware
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
- Single access point
- Single Legal Entity ownership
- Usage rights granted to one or more Organizations
- Reconciliation option defined at Bank Account level
- More flexibility and control
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:
- CE_BANK_ACCOUNT:stores bank account attributes
- CE_BANK_ACCT_USES_ALL : This stores the bank account use attributes specific to Operating Unit (AR, AP) and Legal Entity (Treasury).
- 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
- The link between PO_VENDORS and HZ_PARTIES is PO_VENDORS.party_id.
- The link between PO_VENDOR_SITES_ALL and HZ_PARTY_SITES is PO_VENDOR_SITES_ALL.party_site_id.
- 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
- When a bank Is Created, the banking information will be stored in
IBY_EXT_BANK_ACCOUNTS IBY_EXT_BANK_ACCOUNTS.BANK_id = hz_paties.party_id
- When the Bank is assigned to Vendors then it will be updated in HZ_CODE_ASSIGNMENTS.
HZ_CODE_ASSIGNMENTS.owner_table_id = IBY_EXT_BANK_ACCOUNTS.branch_id.
Internal Bank Accounts & Supplier and Customer Bank Accounts in R12
Related PostsInternal 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..
September 12th, 2007 at 12:11 am
Hi
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?
Thanks
September 12th, 2007 at 2:02 am
Anand,
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?
September 20th, 2007 at 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?
Gareth
September 24th, 2007 at 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
September 27th, 2007 at 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 …..
September 30th, 2007 at 10:43 am
Hi,
PO_VENDORS is now a view in R12.
It’s replaced in fact by AP_SUPPLIERS table.
November 20th, 2007 at 11:13 am
Please,
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.
November 25th, 2007 at 7:23 am
I have already explain in my mail.
November 26th, 2007 at 5:03 pm
[…] http://www.oracleappshub.com/account-payable/r12-ebs-banking-model-in-demanding-and-changing-world/ […]
December 1st, 2007 at 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
http://davidhaimes.wordpress.com/2007/11/21/how-do-i-define-my-legal-entities/
December 7th, 2007 at 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 […]
June 30th, 2008 at 8:57 am
SELECT …
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’
June 30th, 2008 at 7:58 pm
Thanks bhupinder sohal, for sharing this query.
July 8th, 2008 at 5:40 am
Thank You.. It has help me lot
September 26th, 2008 at 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
September 26th, 2008 at 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
September 28th, 2008 at 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 BANK_ACCOUNT_NAME, BANK_ACCOUNT_NUM
FROM IBY_EXT_BANK_ACCOUNTS
WHERE EXT_BANK_ACCOUNT_ID IN
(SELECT EXT_BANK_ACCOUNT_ID
FROM IBY_ACCOUNT_OWNERS
WHERE ACCOUNT_OWNER_PARTY_ID IN
(SELECT party_id
FROM hz_party_sites
WHERE party_site_name = ”))
September 28th, 2008 at 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.
October 21st, 2008 at 7:31 am
[…] R12 : EBS Banking Model in demanding and Changing World […]
September 1st, 2009 at 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.