PDRT Error: ORA-02290: Check Constraint (HR.HR_PER_DATE_OF_DEATH) Violated (Doc ID 2605669.1)

Last updated on JUNE 16, 2022

Applies to:

Symptoms

When attempting to use the DRT tool getting the following error PDRT error: ORA-02290: check constraint (HR.HR_PER_DATE_OF_DEATH) violated


ERROR
-----------------------
PDRT error: ORA-02290: check constraint (HR.HR_PER_DATE_OF_DEATH) violated

From Concurrent Process Logs:

Custom extension processing ending for p_person_id: 1936
process_person(RUN_DML) :: RUN_DML with ID :1936 TYPE : HR
run_dml :: Masking Root with ID :1936 TYPE : HR
run_dml_person :: Masking ID :1936 TYPE : HR
run_dml_person(REMOVE_HR_PERSON) :: ID :1936 TYPE : HR
An error was encountered - -2290 -ERROR- ORA-02290: check constraint (HR.HR_PER_DATE_OF_DEATH) violated
run_dml_person :: Error ID :1936 TYPE : HR
run_dml :: Error Masking Root with ID :1936 TYPE : HR
process_person :: Error ID :1936 TYPE : HR


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. HRMS Manager
2. PDRT tool
3. Try to run the application on a single employee the issue is reported.

Changes

Cause

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