Error ORA-06502: DEAL_ORD_LIB_SQL.FIND_ITEMS_FOR_DEAL On Order Screen
(Doc ID 2573716.1)
Last updated on JUNE 12, 2021
Applies to:Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.
Following error is encountered while recalculating Purchase after applying a deal to it:
Error: Error ORA-06502: PL/SQL: numeric or value error: number precision too large returned by program unit DEAL_ORD_LIB_SQL.FIND_ITEMS_FOR_DAL
Steps to reproduce:
1. Create a deal for multiple items.
2. Create a PO with PO value > 99999999.9999.
3. On Deal head screen, click on More actions -> Re-calculations.
4. Apply deals online.
5. Notice the 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