Oracle
 provides an API to change start dates of a person, the interesting fact
 is that this API even shifts the first assignment start dates. The API 
allows to shift the start dates within the range of first date track 
changes done at person & assignment level, if the new start date 
falls beyond the first date track change records effective end date then
 there is a error which pops up and does not allow changing the start 
date, this is logical and relevant.
If you still want to change the start date, then all person and assignment changes should be removed from the system before trying to change the start date.
Below is the API which helps updating the start date
APP-PAY-06841: Person changes exist between the old date and the new date
ORA-20001: Person changes exist between the old date and the new date.
ORA-06512: at "APPS.HR_CHANGE_START_DATE_API", line 3068
If you still want to change the start date, then all person and assignment changes should be removed from the system before trying to change the start date.
Below is the API which helps updating the start date
DECLARE
l_warn_ee VARCHAR2 (100);
BEGIN
hr_change_start_date_api.update_start_date (p_validate => FALSE,
p_person_id => 8424,
p_old_start_date => TO_DATE ('01-01-2000','MM-DD-YYYY'),
p_new_start_date => TO_DATE ('01-01-2001','MM-DD-YYYY'),
p_update_type => 'E',
p_warn_ee => l_warn_ee
);
DBMS_OUTPUT.put_line (l_warn_ee);
END;
 
No comments:
Post a Comment