My Oracle Support Banner

Daily Purge Fails With Error Message: 'ORA-02292: integrity constraint violated' (Doc ID 2107836.1)

Last updated on APRIL 14, 2021

Applies to:

Oracle Retail Merchandising System - Version 14.0 and later
Information in this document applies to any platform.


In Oracle Retail Merchandising System (RMS), the Daily Purge batch is failing with the below error message if a record exists in the CONCESSION_DATA table.


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

Steps to Recreate:

  1. Add the item to Daily_Purge which is present in CONCESSION_DATA table.
  2. Execute the dlypurge job.
  3. Job fails with the above error.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.