Trading Community Architechture (TCA)
R12 What is TCA?
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 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)
- 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)
No comments:
Post a Comment