RMS Order Purge Is Not Deleteing from PO And PO_DETAIL tables in RWMS
Last updated on JANUARY 09, 2018
Applies to:Oracle Retail Warehouse Management System - Version 12.0.10 and later
Information in this document applies to any platform.
PODEL (purchase order delete) messages in fails in Subscription in RWMS with error : "child record found in table asn_item" (ORA-02292: integrity constraint (schema_owner.ASN_ITEM_REF3) violated - child record found).
Steps to recreate
1. Create ASN with a PO
2. Create ASN appointment with ASN created in Step 1.
3. Print receiving labels
4. Receive the appointment
5. Delete the appointment
6. From 3rd party system, send PODEL message
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