Tuesday 4 March 2014

What are the tables that replaced RA_CUSTOMERS, RA_ADDRESSES_ALL and RA_SITE_USES_ALL ?

The migration of customer data from Oracle Receivables (AR) to the Trading Community Architecture (HZ) is very complex. There isn't a one to one mapping of the old table in AR to a new table in HZ, because the structure of data has completely changed.


Old TableNew Table
RA_CUSTOMERSHZ_PARTIES and HZ_CUST_ACCOUNTS
RA_ADDRESSES_ALLHZ_PARTY_SITES, HZ_LOC_ASSIGNMENTS,
HZ_LOCATIONS and HZ_CUST_ACCT_SITES_ALL
RA_SITE_USES_ALLHZ_CUST_SITE_USES_ALL

No comments:

Post a Comment