My Oracle Support Banner

After Changing NLS Variables, "ORA-06502: PL/SQL: numeric or value error" Occurs When Saving Approved Bill Back Deal (Doc ID 1575321.1)

Last updated on NOVEMBER 23, 2019

Applies to:

Oracle Retail Merchandising System - Version 13.2.5 and later
Information in this document applies to any platform.

Symptoms

In Retail Merchandising System (RMS) 13.2.5, when attempting to save an approved bill back deal after changing National Language Support (NLS) variables, the following error occurs:



In RMS:

  1. Open Deals Maintainance (dealmain.fmb).
  2. Fill in all required fields and choose billing type = 'BILL BACK DEAL'.
  3. Submit form.
  4. Approve form.
  5. Try to save the form.  You will get the error: "ORA-06502: PL/SQL: numeric or value 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.