Hi Friends,
Iam new * to oracle apps. When I run my api hr_assignment_api.update_emp_asg_criteria to upload the values .i am getting the following error.
<b>ORA-20001: HR_FLEX_VALUE_MISSING: N, COLUMN, SEGMENT1, N, PROMPT, Legislative Country</b>
Can any one tell me what is legislative country. wht i shd do to reslove this error. Do Please help me
DECLARE
l_effective_date DATE := to_date('23-SEP-1980', 'DD-MON-YYYY');
l_datetrack_update_mod VARCHAR2 (100) := 'CORRECTION';
l_assignment_id NUMBER := 4;
l_grade_id NUMBER := NULL;
l_position_id NUMBER := 59473;
l_job_id NUMBER := 227;
l_payroll_id NUMBER := NULL;
l_location_id NUMBER := 204;
l_organization_id NUMBER := 626;
l_pay_basis_id NUMBER := NULL;
l_segment1 VARCHAR2 (100);
l_segment2 VARCHAR2 (100);
l_segment3 VARCHAR2 (100);
l_old_obj_ver_number NUMBER;
l_special_ceiling_step_id NUMBER;
l_people_group_id NUMBER;
l_soft_coding_keyflex_id NUMBER;
l_group_name VARCHAR2 (700);
l_effective_start_date DATE;
l_effective_end_date DATE;
l_org_now_no_manager_warning BOOLEAN ;
l_other_manager_warning BOOLEAN ;
l_spp_delete_warning BOOLEAN ;
l_entries_changed VARCHAR2 (100);
l_tax_district_changed_warning BOOLEAN ;
l_concatenated_segments VARCHAR2 (100);
l_gsp_post_process_warning VARCHAR2 (100);
cursor csr_ovn is
select max(object_version_number)
from per_assignments_f where assignment_id=l_assignment_id;
BEGIN
open csr_ovn;
fetch csr_ovn into l_old_obj_ver_number;
close csr_ovn;
hr_assignment_api.update_emp_asg_criteria
(p_effective_date => l_effective_date,
p_datetrack_update_mode => l_datetrack_update_mod,
p_assignment_id => l_assignment_id,
p_validate => NULL,
p_called_from_mass_update => NULL,
p_grade_id => l_grade_id,
p_position_id => l_position_id,
p_job_id => l_job_id,
p_payroll_id => l_payroll_id,
p_location_id => l_location_id,
p_organization_id => l_organization_id,
p_pay_basis_id => l_pay_basis_id,
p_segment1 => l_segment1,
p_segment2 => l_segment2,
p_segment3 => l_segment3,
p_segment4 => NULL,
p_segment5 => NULL,
p_segment6 => NULL,
p_segment7 => NULL,
p_segment8 => NULL,
p_segment9 => NULL,
p_segment10 => NULL,
p_segment11 => NULL,
p_segment12 => NULL,
p_segment13 => NULL,
p_segment14 => NULL,
p_segment15 => NULL,
p_segment16 => NULL,
p_segment17 => NULL,
p_segment18 => NULL,
p_segment19 => NULL,
p_segment20 => NULL,
p_segment21 => NULL,
p_segment22 => NULL,
p_segment23 => NULL,
p_segment24 => NULL,
p_segment25 => NULL,
p_segment26 => NULL,
p_segment27 => NULL,
p_segment28 => NULL,
p_segment29 => NULL,
p_segment30 => NULL,
p_employment_category => NULL,
p_concat_segments => NULL,
p_contract_id => NULL,
p_establishment_id => NULL,
p_scl_segment1 => NULL,
p_grade_ladder_pgm_id => NULL,
p_supervisor_assignment_id => NULL,
p_object_version_number => l_old_obj_ver_number,
p_special_ceiling_step_id => l_special_ceiling_step_id,
p_people_group_id => l_people_group_id,
p_soft_coding_keyflex_id => l_soft_coding_keyflex_id,
p_group_name => l_group_name,
p_effective_start_date => l_effective_start_date,
p_effective_end_date => l_effective_end_date,
p_org_now_no_manager_warning => l_org_now_no_manager_warning,
p_other_manager_warning => l_other_manager_warning,
p_spp_delete_warning => l_spp_delete_warning,
p_entries_changed_warning => l_entries_changed,
p_tax_district_changed_warning => l_tax_district_changed_warning,
p_concatenated_segments => l_concatenated_segments,
p_gsp_post_process_warning => l_gsp_post_process_warning
);
END;
Thanks and Regards,
Dinesh.s
ORA-20001: HR_FLEX_VALUE_MISSING: N, COLUMN, SEGME
-
- Posts: 3
- Joined: Thu Sep 09, 2010 2:49 am
- Location: India
-
- Posts: 3
- Joined: Thu Sep 09, 2010 2:49 am
- Location: India
Who is online
Users browsing this forum: No registered users and 1 guest