Error "ORA-02292: Integrity Constraint" While Running DLYPRG batch
(Doc ID 2487834.1)
Last updated on MAY 11, 2020
Applies to:
Oracle Retail Merchandising System - Version 16.0.1 and laterInformation in this document applies to any platform.
Symptoms
Below error occurs after deleting a department and running the DLYPRG batch.
ERROR
-----------------------
"dlyprg_1~20180911170007~del_dept~DEPS~-2292~ORA-02292: integrity constraint (.) violated - child record found~DELETE in package DELETE_RECORDS_SQL.DEL_DEPS DEPT: 89, key_value=89."
Steps To Reproduce:
- Make sure you have record in VAT_DEPS and HIST_REBUILD_MASK tables for the department.
- Delete Subclass using RMS application.
- Run DLYPRG batch and note the record is deleted from the daily_purge table.
- Delete Class using RMS application.
- Run DLYPRG batch and note the record is deleted from the daily_purge table.
- Delete Department using RMS application.
- Run DLYPRG batch and note the above error.
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 |