Dlyprg Returning ORA-02292 When Deleting Concession Items
(Doc ID 2102203.1)
Last updated on APRIL 30, 2020
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:
- Delete one concession item that has also data in CONCESSION_DATA table
- Run the dlyprg batch
- 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