Friday, October 28, 2011

R12 TCA Bank Model

Your Ad Here


n 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

  • The link between PO_VENDORS and HZ_PARTIES is PO_VENDORS.party_id
  • PO_VENDOR_SITES_ALL.party_site_id = HZ_PARTY_SITES.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, Record will be stored in HZ_LOCATIONS
  • When a bank is Created, information will be stored in IBY_EXT_BANK_ACCOUNTS
    IBY_EXT_BANK_ACCOUNTS.bank_id = HZ_PARTIES.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
  1. CE_BANK_ACCOUNT: Stores bank account attributes
  2. CE_BANK_ACCT_USES_ALL: 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
Your Ad Here


  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer
    LinkedIn profile -
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at | +91 - 9581017828.


  2. Flip Diving: play it now - World's #1 cliff diving game. Pull off Frontflips, Backflips & Gainers from high cliffs, rickety platforms, trees, castles, and trampolines!
    flip diving

  3. That is a good tip especially to those new to the blog here. Brief but very accurate information. Thank you very much. The post was lengthy, but I loved to read it till the last word.
    Oracle Fusion HCM Technical Training Institute