Trading Community Architecture (TCA)

By Vinay | May 5, 2009 | 2,579 views
Category Common, Database, Oracle ADF

  Share


About author  I am Java/oracle professional.Working on Java/J2EE technologies and i.e Oracle ADF,Spring,hibernate,J2ee,PL/sql,Apps for 2+ years.I am passionate about learning new technologies.I am sharing my knowledge. Give your views and suggestion. http://www.linkedin.com/in/vinaykumar2 Read more from this author


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.

  • Delicious
  • Yahoo Buzz
  • Digg
  • DZone
  • Facebook
  • LinkedIn
  • Twitter
  • Share/Bookmark
Read more post on HZ_PARTIES oracle tca TCA Trading Community Architecture 

  Share

3 comments | Add One

Comments

  1. Trupti RakheNo Gravatar - 07/14/2009 at 5:01 am

    Hi Vinay,

    Came accross your post while searching for info regarding TCA Architecture. Its a very simple and useful info for some one who has only heard about TCA.

    Good Going …



  2. vinay kumarNo Gravatar - 07/14/2009 at 5:15 am

    thanks trupti
    If you have more details for TCA. Please share with US



  3. VinodNo Gravatar - 11/4/2009 at 10:04 pm

    Hey Vinay,

    It is good to see your information while searching for TCA information.

    I am very happy to say this.



Trackbacks

Leave a Comment

Name:

E-Mail :

Website :

Comments :