IMPLEMENT_RECOMMENDATION Updates HZ_CUST_PROFILE_AMTS Directly - Business Event Not To Fire (Doc ID 1942364.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Credit Management - Version 12.2.3 and later
Information in this document applies to any platform.


After a case folder is raised and providing a recommendation to increase the credit limit.

AR_CMGT_WF_ENGINE. IMPLEMENT_RECOMMENDATION is calling UPDATE_RECOMMENDATION, which is updating hz_cust_profile_amts directly.
This is causing the subscription to our Business Event to not fire.

We have a business logic associated to this business event which based on the Credit limit goes ahead and releases the orders which are on hold. This is very critical for our business process.

In UPDATE_RECOMMENDATION request to call the standard API ie hz_customer_profile_v2pub.update_cust_profile_amt instead of updating the table directly


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