My Oracle Support Banner

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.

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

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.