Monday 22 January 2018

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

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.

 

          

          

          

         

  

 

 

 Understand Customer TCA Architecture


 

 

 

3 comments:

Anonymous said...

Thanks for Sharing This informative article. It would be helpful if you write a all.
Oracle Fusion HCM Online Training

shaik shah said...

Excellent blog I visit this blog it's really awesome. The important thing is that in this blog content written clearly and understandable. The content of information is very informative.
Oracle Fusion HCM Online Training

Goutham Raj said...

Good Article, Alots of information provided, Thanks for sharing this information.
Oracle Fusion HCM Training

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *