tca architecture in oracle apps?

Question by junaid: tca architecture in oracle apps?

Great answer:

Answer by Johny
Hi,

Today’ s economy requires business strategies and relationships that are both complex and dynamic. The static and independent customer and supplier models typical of other ERP and CRM applications cover only a limited slice of the trading community and cannot adequately represent the reality of today’ s complex business communities.
The Oracle Trading Community was designed to address these gaps and provide a comprehensive yet flexible architecture that can accommodate all players in a trading community and the complicated relationships among them.

Trading Community Model will include not just customers but suppliers, internal organizations, and employees as well. ‘Trading Community’ is meant to represent all members of your business community that are already modelled in the business architecture or that will be incorporated into the architecture in the future.

Most of the table names ends with _HZ. You can relate the legacy system with the current apps version by using interface tables only,

Few interface tables are,

HZ_IMP_ADDRESSES_INT
HZ_IMP_ADDRESSUSES_INT
HZ_IMP_CLASSIFICS_INT
HZ_IMP_CONTACTPTS_INT
HZ_IMP_CONTACTROLES_INT
HZ_IMP_CONTACTS_INT
HZ_IMP_CREDITRTNGS_INT
HZ_IMP_FINNUMBERS_INT
HZ_IMP_FINREPORTS_INT
HZ_IMP_PARTIES_INT
HZ_IMP_RELATIONSHIPS_INT

Mapping of HZ tables to the AR/RA tables from previous releases of Oracle Receivables. This is intended for customers, analysts and Oracle personnel.

Release 11 Schema Release 11i Schema
—————– ——————
RA_CUSTOMERS_ALL HZ_PARTIES,HZ_PERSON_PROFILES,… ILES,HZ_CUSTOMER_ACCOUNTS

RA_ADDRESSES_ALL HZ_PARTY_SITES, HZ_LOCATIONS, HZ_CUST_ACCT_SITES_ALL

RA_PHONES HZ_CONTACT_POINTS

RA_CONTACTS HZ_CUST_ACCCOUNT_ROLES,HZ_ORG_… HZ_PARTY_RELATIONSHIPS

RA_CONTACT_ROLES HZ_ROLE_RESPONSIBILITY

RA_CUSTOMER_RELATIONSHIPS_ALL HZ_CUST_ACCT_RELATE_ALL

RA_SITE_USES_ALL HZ_CUST_SITE_USES_ALL

AR_CUSTOMER_PROFILE_CLASSES HZ_CUSTOMER_PROFILE_CLASSES

AR_CUST_PROF_CLASS_AMOUNTS HZ_CUST_PROF_CLASS_AMOUNTS

AR_CUSTOMER_PROFILES HZ_CUSTOMER_PROFILES

AR_CUSTOMER_PROFILE_AMOUNTS HZ_CUSTOMER_PROFILE_AMOUNTS

Thanks & Regards,
Johny.

Give your answer to this question below!