RMS Order Purge Is Not Deleteing from PO And PO_DETAIL tables in RWMS (Doc ID 2103552.1)

Last updated on FEBRUARY 19, 2016

Applies to:

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

Symptoms

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

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