My Oracle Support Banner

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.

Symptoms

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_LOG shows:

ERROR_SOURCE: APPT_DETAIL_S
ERROR_LOC: Add_By_POList.Build_POItem_List
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_SOURCE: APPT_DETAIL_S
ERROR_LOC: process_add_by_po
ERROR_MSG: 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.