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.

Symptoms

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:

  

 

 

Cause

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