My Oracle Support Banner

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 FEBRUARY 10, 2020

Applies to:

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

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.