DMS Error While Printing Appointment For Predist Orders Having PPS Items

(Doc ID 2213377.1)

Last updated on DECEMBER 19, 2016

Applies to:

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

Symptoms

In RWMS 15.0.x

DMS error while printing appointment for predist order due to exception raised during distribution to paperless picking system (PPS) unit pick system.

Steps To Recreate:
1. Setup PPS in the system.
2. Setup an item for PPS.
3. Created a PO for 5 units each to 2 stores.
4. Create an appointment for the PO.
5. Ensure that a predist wave exists in the facility as available.
6. Printed the appointment.
7. Notice the DMS error.
8. ERROR_LOG shows - ORA-02291: integrity constraint (WMS01.PICKD_PICKT_FK) violated - parent key not found

Changes

 

Cause

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 hundreds of Community platforms