Trading Community Architecture (TCA)

Oracle Trading Community Architecture (TCA) is a data model that allows you to manage complex information about the parties, or customers,.TCA is the global repository for all name and address information, including those of customers and employees. 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:

Organization e.g. ABC corporation
Person e.g. vinay kumar
Group e.g. Silicon group
Relationship e.g. vinay kumar at ABC corporation.

Main components of Oracle TCA

Contacts
Locations
Party Layer
Sites
Relationships
Account Layer
Customer Accounts

Main Tables in TCA

HZ_PARTIES
HZ_RELATIONSHIPS
HZ_RELATIONSHIP_TYPES
HZ_ORG_CONTACTS
HZ_ORG_CONTACT_ROLES
HZ_CONTACT_POINTS
HZ_PARTY_SITES
HZ_LOCATIONS
HZ_ORGANIZATION_PROFILES

A Party is any entity with which have potentially do business. It could be an organization, an individual or a relationship .

A Location is a point in geographical space described by a street address.

An Account represents is the financial realtionship of company with party .

A Party Site links a party with a location, indicating that party’s usage of the location.

An Account Site is a party site that is used by a customer account, for example, for billing or shipping purposes. (Account Sites are Organization specific in Multi-Org terms, just as Customer Sites were.)

A Contact is a person in the context of an organization, modelled as a relationship between an organization and a person or between two people.A Contact Point -is point of contact the party, for example, a phone number, e-mail address.