My Oracle Support Banner

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 later
Information 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:

  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

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.