API "WSH_EXCEPTIONS_PUB" Slow Purging Records Using Parameter "data_older_no_of_days"
Last updated on JULY 19, 2017
Applies to:Oracle Shipping Execution - Version 12.2.6 and later
Information in this document applies to any platform.
On : 12.2.6 version, Open Interfaces & Public APIs
Calling the standard API "WSH_EXCEPTIONS_PUB.Exception_Action" to purge the "NO_ACTION_REQUIRED" status records in WSH_EXCEPTIONS.
Observe that the performance of this API is too slow. The TKPROF shows the following two poorly performing SQL's:
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