Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> HR Assignment API error - Supervisor not valid for duration of the assignment

HR Assignment API error - Supervisor not valid for duration of the assignment

From: Sanchita Sarkar <san_mukh_at_yahoo.com>
Date: 7 Apr 2003 09:54:04 -0700
Message-ID: <c8a45f97.0304070854.46154d92@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US