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