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 laterInformation 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 |