Launch Pick Release Ends in Error - ORA-06502: PL/SQL: numeric or value error: character to number conversion error (Doc ID 947823.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Shipping Execution - Version 11.5.10.0 to 11.5.10.CU2 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 01-Dec-2014***


Symptoms

Pick Release ends in error after reserving lots in OPM inventory.  The log file shows the following.

ERROR
Error occurred in WSH_PR_CRITERIA.Get_Lines
...
Entering WSH_PR_CRITERIA.GET_LINES (WSHPRCRB.pls 115.101) (09/24/2009 02:53:27 PM)
P_ENFORCE_SHIP_SET_AND_SMC ==> Y
Unexpected error has occured. Oracle error message is ORA-06502: PL/SQL: numeric or value
error: character to number conversion error
Exiting WSH_PR_CRITERIA.GET_LINES - EXCEPTION:OTHERS (09/24/2009 02:53:27 PM, .03 seconds)
Current Time is ==> 09/24/2009 02:53:27 PM
WSH_PR_CRITERIA.Get_Lines l_return_status ==> U
l_del_details_tbl.count ==> 0
Error occurred in WSH_PR_CRITERIA.Get_Lines
Error occurred in WSH_PR_CRITERIA.Get_Lines ==>

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Book sales order and reserve inventory.
2. Run pick release for the sales order which ends in 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