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 : Bank & Trading Community Architecture(TCA)

Posted on November 26th, 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

Read this:

  1. http://www.oracleappshub.com/account-payable/r12-ebs-banking-model-in-demanding-and-changing-world/
  2. http://www.oracleappshub.com/account-payable/welcome-to-r12-account-payable/

dgreybarrow-2Three key CE tables now as:

  • CE_BANK_ACCOUNTS for bank accounts
  • CE_BANK_ACCT_USES_ALL for account uses by Operating Units & Legal Entities
  • CE_GL_ACCOUNTS_CCID for bank account use accounting data

dgreybarrow-2TCA and Bank

The TCA party model is being used to model banks and bank branches as parties with the associated attributes of Relationships, Address, Contact and Locations. The TCA tables used by Cash Management for modeling Banks and Bank Branches are listed below:

  1. HZ_PARTIES
  2. HZ_RELATIONSHIPS
  3. HZ_RELATIONSHIP_TYPES
  4. HZ_ORG_CONTACTS
  5. HZ_ORG_CONTACT_ROLES
  6. HZ_CONTACT_POINTS
  7. HZ_PARTY_SITES
  8. HZ_LOCATIONS
  9. HZ_ORGANIZATION_PROFILES

The HZ_ORGANIZATION_PROFILES table stores additional attributes of banks and bank branches along with the history of changes made to Banks and Bank Branches. The contact person at the bank, bank branch and bank account is defined as a party in HZ_PARTIES, while the contact details will be stored in HZ_CONTACT_POINTS (stores contact methods), HZ_ORG_CONTACTS (stores the contact’s title) and HZ_ORG_CONTACT_ROLES (stores the contact’s purpose or role). The address details of Banks and Bank Branches will be in HZ_LOCATIONS (stores addresses) and HZ_PARTY_SITES (stores party sites).

The new table CE_BANK_ACCOUNT stores bank account attributes while the CE_BANK_ACCT_USES_ALL table stores the bank account use attributes specific to Operating Unit (AR, AP) and Legal Entity (Treasury).

The accounting data pertaining to the bank account use will be stored in the CE_GL_ACCOUNTS_CCID table.

All of the bank, branch and bank account related attributes in AP_BANK_BRANCHES and AP_BANK_ACCOUNTS_ALL tables will be upgraded to HZ_PARTIES and the new tables in Cash Management.

Within TCA model, here is various attributes how they fits inside the model.

 

bankTCAMODEL

Related Posts

Posted in EBS Suite, Oracle Payable, R12, Release12 | 2 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
2 Responses
  1. Highlights:Release 12 Financials Says:

    […] R12 : Bank & Trading Community Architecture(TCA) […]

  2. Managing Cash , EBS and SWIFT Says:

    […] R12 : Bank & Trading Community Architecture(TCA) […]