Bank Set-Ups have changed considerably in R12 since 11i.
Prior to R12 of the Oracle E-Business Suite, the Payables application owned the bank, branch, and bank account tables and shared the data with other Oracle applications such as Receivables, Payroll, and Treasury. Since the release of R12, the bank account model has changed in following ways:
- Banks and Bank Branches are created in TCA (Trading Community Architecture) parties. The relationship is one-to-many (each Bank can have one or more Branches).
- The Bank Accounts have a one-to-many relationship with existing Bank Branches (each Bank Branch can have one or more Bank Accounts), but Bank Accounts are owned by the Cash Management application, not TCA.
- During the creation of a new (or updating an existing) Bank Account, you can specify which other installed Oracle applications you want to use the new (or updated) Bank Account with
o Receivables
o Payroll
o Treasury
o Payables
The Bank Accounts are further classified as Internal and External. The basic difference between an Internal bank account and an External bank account is that an internal bank account is created from the Cash Management module and the External Bank/bank accounts are created from the sub-ledger modules such as the Payables or Receivables. Bank Accounts related to Suppliers or Customers are the externals bank accounts. The Internal bank accounts and its details are stored in the CE tables like “CE_BANK_ACCOUNTS” and the external bank accounts and its details are stored in IBY tables like “IBY_EXT_BANK_ACCOUNTS”.
Comments
Post a Comment