Getting the validation error while using hr_change_start_date_api.update_start_date API
Hello,
I am trying to update the employee start date using the API hr_change_start_date_api.update_start_date
The employee per_periods_of_service records are
I am trying to change the start date to 06-JAN-25
hr_change_start_date_api.update_start_date
(p_validate => FALSE ,
p_person_id =>12345,
p_old_start_date => TO_DATE('07-DEC-2024','DD-MON-YYYY'),
p_new_start_date => TO_DATE('06-JAN-2025','DD-MON-YYYY') ,
p_update_type => 'E' ,
p_applicant_number => NULL,
p_warn_ee => lc_warn_ee );
But I am getting the error Exp - ORA-20001: Contiguous periods of service exist.