My Oracle Support Banner

Daily Purge Batch Failure With Integrity Constraint Violated Error (Doc ID 1386517.1)

Last updated on APRIL 02, 2018

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

Symptoms

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.

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.