Skip to main content

Posts

Showing posts from January, 2021

Bank, Bank Branches and Accounts in Oracle R12

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 classif