Customer Workbench Error: Re-activating a Customer Site Business Purpose Calls API HZ_CUST_ACCOUNT_SITE_V2PUB.UPDATE_CUST_SITE_USE and Raises Error: APP-AR-96282 Error: Column created_by module must have a value.
Last updated on JULY 12, 2017
Applies to:Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.
When trying to re-activate Customer Account Site Use using the TCA API or via the Customer Form, Hz_cust_account_site_v2pub.Update_cust_site_use is called and this API gives the following error
APP-AR-96282 Error: Column created_by module must have a value.
STEPS TO REPRODUCE:
Via Customer Interface
- Create Customer Account using Customer Interface
- Query the Customer and inactivate the Account Site
The Account Bill-to site use also gets inactivated.
- Again activate the same Account Site
The Account Bill-to site use remains inactivated.
- Use TCA API to activate the Bill-to site use.
Via Customer Form
Responsibility: Receivables Manager
Navigation: Customers > Customers
Select one of the Addresses > Open
Click on Business Purposes tab and select/ enter a record for Bill-To site use.
Check/ select a site use to reactivate and then save.
When saving the updated business purpose active_flag, you receive the following error.
APP-AR-96282 Error: Column created_by_module must have a value.
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