Human Capital Management - EBS (MOSC)

MOSC Banner

Getting the validation error while using hr_change_start_date_api.update_start_date API

edited Apr 3, 2025 8:50PM in Human Capital Management - EBS (MOSC) 3 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center