API "WSH_EXCEPTIONS_PUB" Slow Purging Records Using Parameter "data_older_no_of_days"

(Doc ID 2288323.1)

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