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

Last updated on JUNE 07, 2024

Applies to:

Oracle Shipping Execution - Version 11.5.10.2 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.

Goal

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

Solution

	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

Do NOT remove RTV Exception = WSH_ISO_RET_APPRV_REQ

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.