Pick Release Fails With Exception occurred in WSH_PICK_LIST.Release_Batch_Sub Error (Doc ID 757227.1)

Last updated on AUGUST 26, 2016

Applies to:

Oracle Shipping Execution - Version 12.0.4 and later
Information in this document applies to any platform.

Symptoms


When attempting to run pick release the following error occurs.

ERROR
Calling program unit INV_PICK_RELEASE_PUB.PICK_RELEASE
SQLCODE: -6508 SQLERRM: ORA-06508: PL/SQL: could not find program unit being called
Exception occurred in WSH_PICK_LIST.Release_Batch_Sub
Unexpected error has occured. Oracle error message is ORA-06508: PL/SQL: could not find program unit being called
Exiting WSH_PICK_LIST.RELEASE_BATCH_SUB - EXCEPTION:OTHERS (12/17/2008 03:00:39 PM, 8.5 seconds)
Return from Release_Batch_Sub
retcode ==> 2
errbuf ==> Exception occurred in WSH_PICK_LIST
Error occurred in Release_Batch_Sub
SQLCODE: 1 SQLERRM: User-Defined Exception


STEPS
The issue can be reproduced at will with the following steps:
1. Using the OM Super User Responsibility, navigate to Shipping> Release Sales Orders>
Release Sales Orders
2. Using the order / release rule, run the process.
3. Fails with above error


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms