Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

R12 : EBS Banking Model in demanding and Changing World

Posted on September 10th, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post 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

redArrowRelease 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

redArrowRelease 11i

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

  • ap_bank_branches
  • ap_bank_accounts_all

redArrowComparing 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.

bankmodel1

redArrowRelease 12 , what is new than

BANKTABLE

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.

redArrowMissing 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.

redArrowInternal 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..

Related Posts

Posted in Functional, Oracle Payable, Technical | 20 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
20 Responses
  1. guru Says:

    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

  2. Fred Says:

    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?

  3. Gareth Roberts Says:

    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

  4. Upendra Says:

    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. When we create Supplier it will not populate in HZ tables Says:

    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. laurent Says:

    Hi,

    PO_VENDORS is now a view in R12.

    It’s replaced in fact by AP_SUPPLIERS table.

  7. Eli Says:

    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.

  8. sanjit Says:

    I have already explain in my mail.

  9. R12 : Bank & Trading Community Architecture(TCA) Says:

    […] http://www.oracleappshub.com/account-payable/r12-ebs-banking-model-in-demanding-and-changing-world/ […]

  10. David Haimes Says:

    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/

  11. Release 12 : Legal Entity uptake Says:

    […] 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. query to link vendors to bank accounts Says:

    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’

  13. Sanjit Anand Says:

    Thanks bhupinder sohal, for sharing this query.

  14. Sudharsana Reddy Says:

    Thank You.. It has help me lot

  15. Sachin Says:

    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. Sachin Says:

    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

  17. Sanjit Anand Says:

    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 = ”))

  18. Sanjit Anand Says:

    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. R12 Supplier Bank - Techno Functional Guide | OracleApps Epicenter Says:

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

  20. Prashant Says:

    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.

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.