RMS Order Purge Is Not Deleteing from PO And PO_DETAIL tables in RWMS
(Doc ID 2103552.1)
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!