Difference between ra_customers and Hz_parties?
Difference between ra_customers and Hz_parties?
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.
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
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
Who is online
Users browsing this forum: No registered users and 5 guests