Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> HR Assignment API error - Supervisor not valid for duration of the assignment
I am using HR Assignment APIs
HR_ASSIGNMENT_API.update_emp_asg_criteria
HR_ASSIGNMENT_API.update_us_emp_asg
in that order to load employee assignments into Oracle HR. In a
situation where the Supervisor's hire date is after the employee's
hire date, I get the above error.
The datetrack_update_mode I am using is 'CORRECTION'
I tried passing the Supervisor's hire date as the assignment start
date for the employee but it doesn't seem to work. I even changed the
datetrack update mode to 'UPDATE'
and received another error.
"ORA-20001: APP-07179 DateTrack update not allowed for a record which
started today"
Any ideas on how I can use the APIs effectively to load employee
assignment data when the Supervisor's start date > employee's start
date.
This is how I am calling the APIs
v_special_ceiling_step_id := hr_api.g_number;
HR_ASSIGNMENT_API.update_emp_asg_criteria (p_validate => v_validate
,p_effective_date =>
v_per_effective_start_date
,p_datetrack_update_mode => 'CORRECTION'
,p_assignment_id => v_assignment_id
,p_object_version_number => v_object_version_number
,p_job_id => v_job_id
,p_location_id => v_location_id
,p_special_ceiling_step_id =>
v_special_ceiling_step_id
,p_effective_start_date =>
v_per_effective_start_date
,p_effective_end_date =>
v_per_effective_end_date
,p_people_group_id => v_people_group_id
,p_group_name => v_group_name
,p_org_now_no_manager_warning =>
v_org_now_no_manager_warning
,p_other_manager_warning => v_other_manager_warning
,p_spp_delete_warning => v_spp_delete_warning
,p_entries_changed_warning =>
v_entries_changed_warning
,p_tax_district_changed_warning =>
v_tax_district_changed_warning ); v_statement := 7; HR_ASSIGNMENT_API.update_us_emp_asg (p_validate => false
,p_effective_date =>
v_per_effective_start_date
,p_datetrack_update_mode => 'CORRECTION'
,p_set_of_books_id => 1 -- v_sob_id
,p_assignment_id => v_assignment_id
,p_object_version_number =>
v_object_version_number
,p_supervisor_id => v_supervisor_id
,p_assignment_number => v_assignment_number
,p_default_code_comb_id => v_glcc_id
,p_comment_id => v_comment_id
,p_soft_coding_keyflex_id =>
v_soft_coding_keyflex_id
,p_effective_start_date =>
v_per_effective_start_date
,p_effective_end_date =>
v_per_effective_end_date
,p_concatenated_segments =>
v_concatenated_segments
,p_no_managers_warning => v_no_managers_warning
,p_other_manager_warning =>
v_other_manager_warning );
Thanks,
Sanchita
Received on Mon Apr 07 2003 - 11:54:04 CDT
![]() |
![]() |