DMS Error Displayed While Trying to Add by PO List to FPR with Details Appointment
(Doc ID 2676320.1)
Last updated on JULY 14, 2020
Applies to:Oracle Retail Warehouse Management System - Version 13.2.6 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.
Getting DMS error when trying to add a PO using "ADD by PO List" option in Appointment detail screen and the appointment fails to be created with item details. The error is seen only when requested qty is more than 999999.
ERROR_MSG: ORA-06502: PL/SQL: numeric or value error: number precision too large ORA-06502: PL/SQL: numeric or value error: number precision too large
Similar issue was reported for Add By PO as well and ERROR_LOG showed below entries:
ERROR_MSG: 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