Tuesday, October 16, 2018

Trading Community Architechture (TCA) In Oracle Apps

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:
PartyRepresents any entity that can enter into business relationships with your organization – Organization, Person, or Group
Party RelationshipA 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
LocationA Street Address
Party SiteAssociates a party with a location, indicating that party’s usage of the location
ContactA person related to an organization, this can be a relationship between an organization and a person as well as between two people
Contact PointYour avenue of contacting a party i.e. a phone number ,e-mail address or fax number
Customer AccountRepresents a customer relationship between your organization and a party
Customer Account SiteA party Site that you use in relation to a customer account, i.e, a bill-to or ship-to address
Customer Account ContactsA 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

SQL Important Queries

  How to delete rows with no where clause The following example deletes  all rows  from the  Person.Person  the table in the AdventureWork...