My Oracle Support Banner

How To Purge Shipping Exceptions - WSH_EXCEPTIONS Master Note (Doc ID 1576170.1)

Last updated on AUGUST 28, 2018

Applies to:

Oracle Shipping Execution - Version to 12.2.2 [Release 11.5.10 to 12.2]
Oracle Shipping Execution - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.


How does one Purge Shipping Exceptions?  This document will walk you through the different ways in which to Purge Shipping Exceptions. 


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
 Shipping Exceptions Review
 Purging Shipping Exceptions through the Resolve/Purge Exceptions Parameters window
 When to Purge Shipping Exceptions
 SQL to find exception name in open status
 SQL for Huge Counts using Cursor Statement
 Sample Script To Purge WSH_EXCEPTIONS
 Sample Script To Change Status from NO_ACTION_REQUIRED to CLOSED
 Sample Script to Close Open Exceptions
 Cannot Purge WSH_EXCEPTIONS TABLE Due to Too Many Closed Exceptions
 Unable To Purge WSH_EXCEPTIONS TABLE Due To Large Volume Of Exceptions Causes Error: ORA-01555 snapshot too old
 Can The Table WSH_EXCEPTIONS Table be Truncated As it is Taking Too Long To Purge Data
 Still Have Questions?

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