My Oracle Support Banner

Hr_assignment_api.create_secondary_emp_asg Failing after applying RUP10 (Doc ID 2375420.1)

Last updated on MARCH 19, 2018

Applies to:

Oracle Human Resources - Version 12.1 HRMS RUP10 and later
Information in this document applies to any platform.


On : 12.1.3 version, Person / Assignment Issues

When attempting to calls hr_assignment_api.create_secondary_emp_asg on the parameter "p_pgp_concat_segments" with additional values which is not defined in KFF structure, the following error can occur.
ORA-06502: PL/SQL: numeric or value error: NULL index table key value.
ORA-06512: line XX

The issue can be reproduced at will with the following steps:

1. The only two segments in KFF has been defined.
2. Run API HR_ASSIGNMENT_API.create_secondary_emp_asg on the parameter "p_pgp_concat_segments" with additional values (Such as '')



l_date date := to_date('16-MAR-2018','DD-MON-YYYY');
l_assignment_number varchar2(30);
l_group_name varchar2(100);
l_concatenated_segments varchar2(100);
l_cagr_grade_def_id number;
l_cagr_concatenated_segments varchar2(100);
l_assignment_id number;
l_soft_coding_keyflex_id number;
l_effective_end_date date;
l_assignment_sequence number;
l_comment_id number;
l_other_manager_warning boolean;
l_hourly_salaried_warning boolean;
l_gsp_post_process_warning varchar2(100);
l_people_group_id number := NULL;
l_ovn number;
l_person_id number := 34;
l_organization_id number := 78;
l_payroll_id number := 16;
l_location_id number :=292;

(p_validate => FALSE,
p_effective_date => to_date('18-MAR-2018','DD-MON-YYYY'),
p_person_id => l_person_id,
p_organization_id => l_organization_id,
p_payroll_id => l_payroll_id,
p_location_id => l_location_id,
p_assignment_number => l_assignment_number,
p_group_name => l_group_name,
p_concatenated_segments => l_concatenated_segments,
p_cagr_grade_def_id => l_cagr_grade_def_id,
p_cagr_concatenated_segments => l_cagr_concatenated_segments,
p_assignment_id => l_assignment_id,
p_soft_coding_keyflex_id => l_soft_coding_keyflex_id,
p_people_group_id => l_people_group_id,
p_object_version_number => l_ovn,
p_effective_start_date => l_date,
p_effective_end_date => l_effective_end_date,
p_assignment_sequence => l_assignment_sequence,
p_comment_id => l_comment_id,
p_other_manager_warning => l_other_manager_warning,
p_hourly_salaried_warning => l_hourly_salaried_warning,
p_gsp_post_process_warning => l_gsp_post_process_warning,
P_PGP_CONCAT_SEGMENTS => '');  -- if "" has been set, this would be OK






To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.