Scribd
Upload
242 views

Oracle Trading Community Architecture

Oracle Trading Community Architecture (TCA) is a data model that allows managing information about parties in a commercial community, including organizations, locations, and relationships. The TCA registry is the single source of trading information used by Oracle E-Business Suite applications to view, create and update registry data. TCA includes key entities like parties, customer accounts, locations and contacts.

Uploaded by

Madhavan Eyunni
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
242 views

Oracle Trading Community Architecture

Oracle Trading Community Architecture (TCA) is a data model that allows managing information about parties in a commercial community, including organizations, locations, and relationships. The TCA registry is the single source of trading information used by Oracle E-Business Suite applications to view, create and update registry data. TCA includes key entities like parties, customer accounts, locations and contacts.

Uploaded by

Madhavan Eyunni
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Oracle 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, who belong to your commercial community, including organizations, locations, and the network of hierarchical relationships among them using the TCA registry. TCA registry is the single source of trading community information for Oracle E-Business Suite applications which provide user interfaces, batch data entry functionality, and other features to view, create, and update Registry information. TCA key entities: Parties: Parties are the entities of type person/organization that enter into a business relationship Party Sites: Addresses of the parties Customers: Parties with whom you have a selling relationship Customer Accounts: The business relationships between you and your customers Customer Account Sites: Address of the party used in the case of customer accounts Locations: Geo-spatial points, usually defined by an address Contacts: People who have a contact or employment relationship with an organization or person Contact Points: Means of contact, for example, phone and e-mail address Process Flow: This diagram shows the process flow for managing, searching, creating, and updating customer information. R12 Trading Community Architecture: Includes following new trading entities: Bank and Bank Branches Customers Suppliers TCA-Bank and Bank Branches: The TCA tables used by Cash Management for modeling Banks and Bank Branches are listed below: 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 TCA-Customers: The word Customer is the combination of both the Party layer and the Account layer. Party layer exists independent of any selling or buying relationship. Customer Account layer exists in the context of a Party and only when a selling relationship exists. The Party Layer captures intrinsic truths about a person or organization. The Account Layer captures the details describing the Partys financial relationship with the implementing organization. The Account Layer cannot exist without the Party Layer. TCA-Suppliers: Following are the three new AP tables technical details for R12 Supplier in TCA. They have the links to TCA tables which are listed below. AP_SUPPLIERS HZ_PARTIES HZ_PERSON_PROFILES HZ_PARTY_USAGE_ASSIGNMENTS HZ_PARTY_RELATIONSHIPS AP_SUPPLIER_SITES_ALL HZ_LOCATIONS HZ_LOCATION_PROFILE

o o o

1. 2. 3. 4.

1. 2.

3. HZ_PARTY_SITES 4. HZ_PARTY_SITE_USES AP_SUPPLIER_CONTACTS 1. HZ_PARTIES 2. HZ_RELATIONSHIPS 3. HZ_PARTY_SITES 4. HZ_ORG_CONTACTS 5. HZ_CONTACT_POINTS TCA ER-Diagram:

You might also like