ERPstuff - Oracle EBS Community

difference between ra_customers and Hz_parties pls reply

In older versions of Oracle (10.7 etc.) all the customer data (e.g.
customer name) was in AR tables.

Later Oracle implemented the Trading Community Architecture and came up with HZ tables. So now the customer info is in HZ_CUSTOMERS.

But to ensure backward compatibility, Oracle turned all AR tables into
views based on HZ tables.

E.g you will notice that AR_CUSTOMERS is not a table. It is a view
based on HZ_CUSTOMERS and HZ_PARTIES.

So when you run the customer interface program, HZ_CUSTOMERS table will get updated and those updates will also appear in AR_CUSTOMERS since it is a view.

[quote]In older versions of Oracle (10.7 etc.) all the customer data (e.g.
customer name) was in AR tables.

Later Oracle implemented the Trading Community Architecture and came up with HZ tables. So now the customer info is in HZ_CUSTOMERS.

But to ensure backward compatibility, Oracle turned all AR tables into
views based on HZ tables.

E.g you will notice that AR_CUSTOMERS is not a table. It is a view
based on HZ_CUSTOMERS and HZ_PARTIES.

So when you run the customer interface program, HZ_CUSTOMERS table will get updated and those updates will also appear in AR_CUSTOMERS since it is a view.

<i><div align="right">Originally posted by roy