Understand Customer TCA Architecture

Understand Customer TCA Architecture

In this post I will share you the Whole Customer TCA Architecture and its relation with each other. I am sharing you the Customer TCA architecture ,which helps to understand customer data linking in oracle apps. This TCA architecture helps to understand the customer data and use to interface and upload customer date from external sources.

RA_CUSTOMERS_INTERFACE

Customer Reference	Name	Address Reference	Address	Site Code
C1001	ACME	A2001	200 Main	BILL_TO
C1001	ACME	A2001	200 Main	SHIP_TO
C1001	ACME	A2002	550 State	SHIP_TO

RA_CUSTOMER_PROFILES_INTERFACE

Customer Reference	Address Reference	Profile Name
C1001		Good

RA_CONTACT_PHONES_INTERFACE

Customer Reference	Address Reference	Contact Reference	Last Name	Phone Reference	Phone Number
C1001	A2001	S4001	KWAN	S5001	555-1234
C1001	A2001	S4001	KWAN	S5002	555-7000
C1001	A2001	S4002	SMITH
C1001	A2001			S5003	474-8664
C1001	A2002	S4003	BASS
C1001		S4004	RUDIN
C1001				S5004	506-7000
Table 1 - 13. (Page 1 of 1)

 

   To import a customer with multiple addresses:

• Enter multiple records into RA_CUSTOMERS_INTERFACE with identical ORIG_SYSTEM_CUSTOMER_REF values, but different ORIG_SYSTEM_ADDRESS_REF values.

   To import a customer with multiple contacts:

• Enter multiple records into RA_CONTACT_PHONES_INTERFACE with identical ORIG_SYSTEM_CUSTOMER_REF values, but different ORIG_SYSTEM_CONTACT_REF values.

   To import a customer with multiple telephone numbers:

• Enter multiple records into RA_CONTACT_PHONES_INTERFACE with identical ORIG_SYSTEM_CUSTOMER_REF values, but different ORIG_SYSTEM_TELEPHONE_REF values.

   To import an address with multiple business purposes:

• Enter multiple records into RA_CUSTOMERS_INTERFACE with identical ORIG_SYSTEM_CUSTOMER_REF and ORIG_SYSTEM_ADDRESS_REF values, but different SITE_USE_CODES values.

   To import an address with multiple contacts:

• Enter multiple records into RA_CONTACT_PHONES_INTERFACE with identical ORIG_SYSTEM_CUSTOMER_REF and ORIG_SYSTEM_ADDRESS_REF values, but different ORIG_SYSTEM_CONTACT_REF values.

   To import an address with multiple telephone numbers:

• Enter multiple records into RA_CONTACT_PHONES_INTERFACE with identical ORIG_SYSTEM_CUSTOMER_REF and ORIG_SYSTEM_ADDRESS_REF values, but different ORIG_SYSTEM_TELEPHONE_REF values.

   To import a contact with multiple telephone numbers:

• Enter multiple records into RA_CONTACT_PHONES_INTERFACE with identical ORIG_SYSTEM_CUSTOMER_REF and ORIG_SYSTEM_CONTACT_REF values, but different ORIG_SYSTEM_TELEPHONE_REF values.

 

          

          

          

         

  

 

 

 Understand Customer TCA Architecture