ORA-20001: HR_FLEX_VALUE_MISSING: N, COLUMN, SEGME

[Denish.shan]

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

[ERP_GURU]

Hi Denish,

I think you are getting this error because you are supplying null value to segemnt 1. To resolve this error you may uncheck the 'required' check box for this segment in the Assignments DFF from application developer responsibility.

Please let me know what you get.

Thanks!!

[Denish.shan]

Hi ERP Guru,
thanks for valuable your reply. I have sloved this problem. I have just passed null value for people_group_id. it was creating problem. after I have passed the correct value for people_group_id . My code is working fine for update and correction