Hr_assignment_api.create_secondary_emp_asg Failing after applying RUP10
(Doc ID 2375420.1)
Last updated on APRIL 09, 2021
Applies to:
Oracle Human Resources - Version 12.1 HRMS RUP10 and laterInformation 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.
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 := '&person_id';
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! |
In this Document
Symptoms |
Cause |
Solution |
References |