My Oracle Support Banner

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.

Symptoms

When trying to range locations using group type as store class on Item Location [itemloc] screen, the following error occurs:

Error
"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.

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
References


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