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

Last updated on NOVEMBER 15, 2016

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

Symptoms

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)
P_APPEND_FLAG ==> N
P_USE_HEADER_FLAG ==>
P_DEL_DETAILS_TBL.COUNT ==> 2
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)
G_OTM_PROFILE_VALUE ==> N
Exiting WSH_UTIL_CORE.GET_OTM_INSTALL_PROFILE_VALUE (01/25/2012 10:52:19 AM, .01 seconds)
G_FTE_IS_INSTALLED ==> N
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

 

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

Changes

Recently upgraded from 11.5.8 to 12.1.3

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