My Oracle Support Banner

API "WSH_EXCEPTIONS_PUB" Slow Purging Records Using Parameter "data_older_no_of_days" (Doc ID 2288323.1)

Last updated on MARCH 10, 2019

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:





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.