My Oracle Support Banner

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

Last updated on JUNE 21, 2023

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]
Oracle Shipping Execution - Version 12.2.7 to 12.2.7 [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
 Note: In the images bellow and/or the attached document, user details / company name / address / email / telephone number represents fictitious sample (based upon made up data used in the Oracle Demo Vision instance).
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
 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.