Monday, 22 January 2018

Understand Customer TCA Architecture



In this post I will share you the Whole Customer TCA Architecture and its relation with each other.



RA_CUSTOMERS_INTERFACE

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

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)

 

http://docs.oracle.com/cd/A60725_05/html/comnls/us/ar/t_tskarw.gif   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.

http://docs.oracle.com/cd/A60725_05/html/comnls/us/ar/t_tskarw.gif   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.

http://docs.oracle.com/cd/A60725_05/html/comnls/us/ar/t_tskarw.gif   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.

http://docs.oracle.com/cd/A60725_05/html/comnls/us/ar/t_tskarw.gif   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.

http://docs.oracle.com/cd/A60725_05/html/comnls/us/ar/t_tskarw.gif   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.

http://docs.oracle.com/cd/A60725_05/html/comnls/us/ar/t_tskarw.gif   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.

http://docs.oracle.com/cd/A60725_05/html/comnls/us/ar/t_tskarw.gif   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.

 

          

          

          

         

  

 

 

 

 

 

 

0 comments:

Post a Comment