My Oracle Support Banner

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

Last updated on SEPTEMBER 29, 2020

Applies to:

Oracle Human Resources - Version 12.1 HRMS RUP11 and later
Information in this document applies to any platform.

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

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
Changes
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.