Cannot Purge WSH_EXCEPTIONS TABLE Due to Too Many Closed Exceptions (Doc ID 1079743.1)

Last updated on AUGUST 21, 2023

Applies to:

Symptoms

You are attempting to purge old and un-wanted shipping exceptions from the WSH_EXCEPTIONS table using the purge tool from within the shipping Exceptions form,  but this is taking many hours to complete and/or ends with a 'rollback segment too small' error message.   So you then attempted to use the API WSH_EXCEPTIONS_PUB.Exception_Action to purge old shipping exceptions from the WSH_EXCEPTIONS table. However, when you attempt to execute the API, the program runs for a long time, encounters an error, and rolls back all updates.

EXPECTED BEHAVIOR
-----------------------
Expect to be able to purge all un-wanted exceptions from the WSH_EXCEPTIONS table.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  Create wrapper code which defines input variables, then calls the API  WSH_EXCEPTIONS_PUB.Exception_Action.
2.  Execute the wrapper code.
3.  Wrapper code runs for a very long time.
4.  When the program appears to complete,  query the WSH_EXCEPTIONS table and see that nothing was purged

Changes

Cause

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