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 MARCH 20, 2025

Applies to:

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.

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.