Definition : Oracle Trading Community Architecture (TCA) is a data model that allows to manage complex information about the Customers, Contacts, Employees, Partners,Distributors, Suppliers, Banks, organizations, locations, and the network of hierarchical relationships.
1 Party:
Person - A unique individual (dead or alive) of interest to the user.
Organization - A legal entity recognized by some government authority.
Group - A combination of two or more people, organizations or groups.
2 Party Relationship:
Has a Role - Specifies the nature of the relationship between parties
(e.g., member of, contact at, married to).
Indicates the Nature of the relationship - hierarchy or matrix.
Indicates the Direction of the relationship - superior – subordinate.
Can become a Party - a Relationship becomes a party in itself.
3 Party Site:
It links a Party with a Location
Describes the usage of that Location for the Party
(e.g., mailing address, billing address, home address, etc.).
4 Location:
is a point in geographical space described by a street address.
Any number of location types can be defined. (e.g., bill-to, ship-to, mail-to).
5 Contact:
is a person in the context of an organization, modeled as a relationship between an organization and a person or between two people,
6 Contact Point:
is a means of contacting a party,(eg: a phone number, e-mail address, or fax number).
7 Customer Account:
the business (selling) relationship that a company deploying Oracle Applications has with a party. Stores details about the Financial relationship between a Party and your business. A Party may have one or more Customer Accounts.
8 Customer Account Site:
is a party site that is used by a customer account,(eg: for billing or shipping purposes.)
9 Customer Account Contacts:
A party contact that is used as a means of contacting the customer regarding his/her account.
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
1 Party:
Person - A unique individual (dead or alive) of interest to the user.
Organization - A legal entity recognized by some government authority.
Group - A combination of two or more people, organizations or groups.
2 Party Relationship:
Has a Role - Specifies the nature of the relationship between parties
(e.g., member of, contact at, married to).
Indicates the Nature of the relationship - hierarchy or matrix.
Indicates the Direction of the relationship - superior – subordinate.
Can become a Party - a Relationship becomes a party in itself.
3 Party Site:
It links a Party with a Location
Describes the usage of that Location for the Party
(e.g., mailing address, billing address, home address, etc.).
4 Location:
is a point in geographical space described by a street address.
Any number of location types can be defined. (e.g., bill-to, ship-to, mail-to).
5 Contact:
is a person in the context of an organization, modeled as a relationship between an organization and a person or between two people,
6 Contact Point:
is a means of contacting a party,(eg: a phone number, e-mail address, or fax number).
7 Customer Account:
the business (selling) relationship that a company deploying Oracle Applications has with a party. Stores details about the Financial relationship between a Party and your business. A Party may have one or more Customer Accounts.
8 Customer Account Site:
is a party site that is used by a customer account,(eg: for billing or shipping purposes.)
9 Customer Account Contacts:
A party contact that is used as a means of contacting the customer regarding his/her account.
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