What do you mean by HZ_ in customer tables ?

Showing Answers 1 - 5 of 5 Answers


  • Oct 31st, 2005

hiHZ is used for the customer tables. As for receivables its AR, for payables it AP. for customers in oracle apps HZ is used and TCA also uses HZ before its table name for easy identification of cutomer tables

  Was this answer useful?  Yes


  • Jan 5th, 2006

hz stores the customer information

some table which stores customer information

hz_parties     -> store oraganization and people information

hz_cust_accounts -> sores customer informatiom

hz_cust_acct_sites_all->customers site info like bill-to ship-to

hz_cust_site_use_all->stores the business requirement of the site

hz_location->physical location address of customers

  Was this answer useful?  Yes


  • Aug 16th, 2007

HZ is a profile option. All the customer related tables starts with HZ

  Was this answer useful?  Yes


  • May 9th, 2013

HZ_ stands for human Zone

  Was this answer useful?  Yes

Naresh Bandla

  • Jun 24th, 2015

In R122 we use to store supplier/customers data in different tables, where as In R12 Oracle has introduced TCA(Trading Community Architecture) which will bring both Supplier/Customer data under one umbrella(TCA).
All the data stored in HZ tables in R12.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions