Trading Community Architechture (TCA)

R12  What is TCA?

• Oracle Trading Community Architecture (TCA) is a data model that allows you to manage complex information about the parties, or customers.
• Trading Community Architecture is the implementation of technology and applications to allow users to create and maintain relationships among entities. It is a way to understand who your customer interacts with inside and outside the enterprise.

Note: Customer, Vendor, Supplier are the terms that we come across very frequently.
For instance: We buy goods from a Shop Vendor so we are the Customer to that Vendor and the Vendor is our Supplier for that good. The Vendor gets goods from a merchant who actually produces it (Manufacturer), so now the vendor in-turn becomes a customer to the Manufacturer who is the Supplier.
The complete TCA can be related and runs around all these terms, these may be people we meet generally who might be a Supplier or Customer in our perspective.
Now moving ahead lets go in details about TCA.

TCA Data Model Components:
Party	Represents any entity that can enter into business relationships with your organization – Organization, Person, or Group
Party Relationship	A binary relationship between two parties such as a partnership. Example: Adam is a specific person party and Eve Inc. is an organization party. Adam at Eve Inc. is also treated as a party with the type relationship
Location	A Street Address
Party Site	Associates a party with a location, indicating that party’s usage of the location
Contact	A person related to an organization, this can be a relationship between an organization and a person as well as between two people
Contact Point	Your avenue of contacting a party i.e. a phone number ,e-mail address or fax number
Customer Account	Represents a customer relationship between your organization and a party
Customer Account Site	A party Site that you use in relation to a customer account, i.e, a bill-to or ship-to address
Customer Account Contacts	A party contact that is used as a means of contacting the customer regarding his/her account

TCA Structure We have to cover all the below:

1)Custom /supplier/Vendoe details
2)Bank account details

Bank Account Details in 11i: 
Ap_bank_accounts
ap_bank_accounts_all

Bank accounts in R12:
CE_BANK_ACCOUNTS
CE_BANK_ACCT_USES_ALL
CE_GL_ACCOUNTS_CCID
 R12 credit card tables: Credit card related entry we can find in (iby_fndcpt_instr and iby_fndcpt_instr_assignments tables)