Daily Purge Batch Failure With Integrity Constraint Violated Error

(Doc ID 1386517.1)

Last updated on MARCH 31, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.0 and later
Information in this document applies to any platform.
Checked for relevance on 31-March-2016


When attempting to run the dlyprg batch the following error occurs.

dlyprg_1~20110615104126~del_item~ITEM_MASTER~-2292~ORA-02292: integrity constraint (.) violated - child record found~DELETE in package DEL_ITEM ITEM: 100115989, key_value=100115989.

Steps To Recreate:

1. Run the DLYPRG Batch.
2. DLYPRG Batch aborts.


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