My Oracle Support Banner

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

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