My Oracle Support Banner

Error ORA-02292 When Running Daily Purge (DLYPRG) (Doc ID 2835314.1)

Last updated on JANUARY 26, 2022

Applies to:

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

Symptoms


The purge process isn't managing to delete record from item_master, as it show an error that when found child records, but there are no more records in the child table.

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


@0PACKAGE_ERROR@1ORA-02292: restrição de integridade (ILI_IEM_FK2) violada - registro filho localizado@2DEL_ITEM

ERROR
-----------------------
ORA-02292


Work around exists, but need a solution


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
During execution of a batch process

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!


In this Document
Symptoms
Cause
Solution
References


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