My Oracle Support Banner

Dlyprg Returning ORA-02292 When Deleting Concession Items (Doc ID 2102203.1)

Last updated on MAY 16, 2022

Applies to:

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


In Oracle Retail Merchandising System (RMS) 13.2.4 version, the daily purge [dlyprg] batch cannot handle concession items.  When a concession item with existing records in CONCESSION_DATA is deleted, the purge batch will fail due to an integrity constraint violation error:

Steps to Reproduce:

  1. Delete one concession item that has also data in CONCESSION_DATA table
  2. Run the dlyprg batch
  3. Check the error log file and notice the error:  del_item~ITEM_MASTER~-2292~ORA-02292: integrity constraint (.) violated - child record found~DELETE in package DEL_ITEM ITEM: item_id key_value=item_id




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.