1 of 9

TCA in R12

Santosh Kumar

HighPoint Consulting

2 of 9

What is Trading Community Architecture (TCA)?

  • Trading Community Architecture is a Very flexible, very robust model which defines the components involve in trading within in E-business Suite.
  • The implementation of technology and applications to allow users to create and maintain relationships among entities
  • The universal data schema for customers, prospects, suppliers, distributors, resellers, consortiums, bank across all Oracle EBS applications

3 of 9

TCA Integration with Other Oracle Products

4 of 9

TCA Terminologies

  • The concept of ‘Party’ enables the Customer Model to treat all business entities equally, regardless of type. It easily handles B2B, B2C.�Parties of type ‘Group’ allow for the grouping of any number of other parties into a single entity which enable modeling of households and buying consortiums.
  • Parties of type ‘Relationship’ allow for the relationship between two parties to be viewed as a party in its own right
  • Party - A Party is an entity that can enter into a business relationship and can be of four types.
    • Person - A unique individual (dead or alive) of interest to the owner of the software.
    • Organization - A legal entity recognized by some government authority.
    • Group - a combination of two or more people, organizations or groups of created for the use of the owner of the software.
    • Relationship - The association between an individual person and an organization. Usually a contact at an organization or group.

5 of 9

Party Model

6 of 9

TCA - Suppliers

7 of 9

Supplier/Sites Mapping to TCA Objects

8 of 9

TCA – Banks

9 of 9

Key Tables for Banks

  • Three 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