Error "ORA-02292: Integrity Constraint" While Running DLYPRG batch (Doc ID 2487834.1)

Last updated on MAY 11, 2020

Applies to:

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:

1. Make sure you have record in VAT_DEPS and HIST_REBUILD_MASK tables for the department.
2. Delete Subclass using RMS application.
3. Run DLYPRG batch and note the record is deleted from the daily_purge table.
4. Delete Class using RMS application.
5. Run DLYPRG batch and note the record is deleted from the daily_purge table.
6. Delete Department using RMS application.
7. Run DLYPRG batch and note the above error.

Cause

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