My Oracle Support Banner

DMS Error is Encountered When Attempting to Click "Add by PO" in Appointment Detail Screen (Doc ID 2377019.1)

Last updated on MARCH 26, 2018

Applies to:

Oracle Retail Warehouse Management System - Version 15.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to  create Purchase Order(PO) type of Appointment in Appointment detail window, Click "Add By PO", following error occurs.

Error: DMS error, please see your administrator

Steps To Recreate:
1. Create a PO which is having requested_unit_qty greater than 20000.
2. Start creating PO type of Appointment.
3. In Appointment detail window, when selected 'Add by PO', DMS Error is seen.

Entry in ERROR_LOG table:
ERROR_SOURCE: APPT_DETAIL_S    
ERROR_LOC: process_add_by_po    
ERROR_MSG: ORA-06502: PL/SQL: numeric or value error ORA-0000: normal, successful completion.

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!


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