Itemloc Screen Shows "ORA-06502" Error When Ranging Locations Using Store Class for Group Type Option
(Doc ID 2218881.1)
Last updated on FEBRUARY 26, 2019
Applies to:Oracle Retail Merchandising System - Version 15.0 to 15.0.1 [Release 15.0]
Information in this document applies to any platform.
When trying to range locations using group type as store class on Item Location [itemloc] screen, the following error occurs:
"Error ORA-06502: PL/SQL numeric or value error : character to number conversion error returned by program unit."
Steps To Recreate:
1. Create an item and range it to Store Class.
2. Click on Apply button, it goes to background processing.
3. Notice the error returned. ORA 06502 : PLSQL Numeric to Value conversion error.
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