My Oracle Support Banner

Pick Release Ends in Error: Error occurred in WSH_PICK_LIST.Autocreate_Deliveries (Doc ID 1400622.1)

Last updated on APRIL 30, 2018

Applies to:

Oracle Shipping Execution - Version 12.0.0 and later
Information in this document applies to any platform.
Executable:WSHPSGL - Pick Selection List Generation


Unable to pick release any orders. When running the pick release the program completes with error.

The pick release log file (WSHPSGL module: Pick Selection List Generation) shows the following error: WSH_PICK_LIST.AUTOCREATE_DELIVERIES (WSHPGSLB.pls 120.44.12010000.16) (01/25/2012 10:52:19 AM)
Entering WSH_UTIL_CORE.FTE_IS_INSTALLED (WSHUTCOB.pls 120.21.12010000.7) (01/25/2012 10:52:19 AM)
Entering FTE_ENABLED.CHECK_STATUS () (01/25/2012 10:52:19 AM)
Exiting FTE_ENABLED.CHECK_STATUS (01/25/2012 10:52:19 AM, .01 seconds)
Entering WSH_UTIL_CORE.GET_OTM_INSTALL_PROFILE_VALUE (WSHUTCOB.pls 120.21.12010000.7) (01/25/2012 10:52:19 AM)
Exiting WSH_UTIL_CORE.GET_OTM_INSTALL_PROFILE_VALUE (01/25/2012 10:52:19 AM, .01 seconds)
Exiting WSH_UTIL_CORE.FTE_IS_INSTALLED (01/25/2012 10:52:19 AM, .17 seconds)
det. tab count: 2 ==>
Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries
Current Time is ==> 01/25/2012 10:52:19 AM
Unexpected error has occured. Oracle error message is ORA-06508: PL/SQL: could not find program unit being called
Exiting WSH_PICK_LIST.AUTOCREATE_DELIVERIES - EXCEPTION:OTHERS (01/25/2012 10:52:23 AM, 3.82 seconds)
Current Time is ==> 01/25/2012 10:52:23 AM
WSH_PICK_LIST.Autocreate_Deliveries l_return_status ==> U
Error occurred in WSH_PICK_LIST.Autocreate_Deliveries
SQLCODE: 1 SQLERRM: User-Defined Exception
Exception occurred in WSH_PICK_LIST.Release_Batch_Sub
Exiting WSH_PICK_LIST.RELEASE_BATCH_SUB - EXCEPTION:E_RETURN (01/25/2012 10:52:23 AM, 10.84 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
Exception occurred in WSH_PICK_LIST


Responsibility: OM Super User
Navigation: Shipping -- Release Sales Orders -- Release Sales Orders


Recently upgraded from 11.5.8 to 12.1.3


To view full details, 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 a vibrant support community of peers and Oracle experts.