What is Trading Community Architecture in Oracle Application 11i

Oracle Trading Community Architecture (TCA) is a data model that allows you to manage complex information about the parties, or customers, who belong to your commercial community, including organizations, locations, and the network of hierarchical relationships among them. This information is maintained in the TCA Registry, which is the single source of trading community information for Oracle E-Business Suite applications. These applications, as well as TCA itself, provide user interfaces, batch data entry functionality, and other features for you to view, create, and update Registry information (Source Overview Oracle® Trading Community Architecture User Guide)

The parties in TCA could be one of following four types:

  1. Organization e.g. Dawlance
  2. Person e.g. Ahmad Bilal
  3. Group e.g. IEEE Consortium
  4. Relationship e.g. Ahmad Bilal at Dawlance.

Following are main components of Oracle TCA

  1. Contacts
  2. Locations
  3. Party Layer
    1. Sites
    2. Relationships
  4. Account Layer
  5. Customer Accounts

Main Tables in TCA

  1. HZ_PARTIES
  2. HZ_LOCATIONS
  3. HZ_PARTY_SITES
  4. HZ_CUST_ACCT_SITES_ALL
  5. HZ_CUST_SITE_USES_ALL
  6. HZ_CUST_CONTACT_POINTS
Advertisements

8 thoughts on “What is Trading Community Architecture in Oracle Application 11i

  1. Dear Ahmad Bilal,

    You notes are excellent. Could you please write to me names of books that can give me more infomation on Oracle Apps – Financials.

    With Regards,
    Dhason Padmakumar

  2. I was wondering what would be a good book or source online to start on TCA. I need to know all about the trading community architecture .. please help

  3. Pingback: Customer Service Center – CRM Process « Susmito Ray

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s