My Oracle Support Banner

Customer Interface Issue: After Upgrade To R12 HZ_CUSTOMER_PROFILES.Standard_Terms Contains No Value For All Customer Profiles (Doc ID 1631920.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.


HZ_CUSTOMER_PROFILE was populating the STANDARD_TERMS column for all account profiles in Release 11i.

You upgraded to Release 12 and discovered that while you were creating customers, when saving the record of the customer, the following error occurs:

Balance Forward Billing is enabled. Please provide bill level data and type.

You don't want to use Balance Forward Billing you you uncheck the Balance Forward Billing option:

Responsibility:  Receivables
Navigation:  Customers > Profile Classes
Query the default profile and uncheck the Balance Forward Billing.
The system will prompt you an Update option, in that you have ticked, update all profiles.

Then concurrent program "Customer Profile Copy" was submitted and after the program completes,

In R12, HZ_CUSTOMER_PROFILES.standard_terms column is NULL for all customers using that profile class.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.