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.

Symptoms

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.
 
ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error: NULL index table key value.
ORA-06512: "APPS.HR_ASSIGNMENT_API", line XXX
ORA-06512: line XX

STEPS
-----------------------
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 'TEST.one.')

ex:

-----

declare
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;

begin
hr_assignment_api.create_secondary_emp_asg
(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 => 'TEST.one.');  -- if "TEST.one" has been set, this would be OK
end;
/

 

commit;

 

-----


Cause

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.