Customer Interface Issue: After Upgrade To R12 HZ_CUSTOMER_PROFILES.Standard_Terms Contains No Value For All Customer Profiles
Last updated on JANUARY 08, 2018
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:
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms