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

Last updated on MAY 31, 2016

Applies to:

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

Symptoms

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

Cause

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