Call To HR_SIT_API.create_sit Failing (Doc ID 2181576.1)

Last updated on OCTOBER 17, 2023

Applies to:

Symptoms

On : 12.2.5 version, Person / Assignment Issues

When attempting to calls HR_SIT_API.create_sit with additional parameter 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_SIT_API", line XXX
ORA-06512: line XX

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  Run API HR_SIT_API.create_sit with additional parameter

ex:

-----

declare

l_anylysis_criteria_id number;
l_person_analysis_id number;
l_pea_object_version_number number:=2;

begin
l_anylysis_criteria_id := NULL;

hr_sit_api.create_sit
(p_validate =>false
,p_person_id => 22807
,p_business_group_id => 202
,p_id_flex_num => 53865
,p_effective_date => sysdate
,p_segment1 => 'TEST'
,p_segment2 => '900'
,p_segment3 => '9ff'   -- additional segment which is not set up in KFF form
,p_analysis_criteria_id => l_anylysis_criteria_id
,p_person_analysis_id => l_person_analysis_id
,p_pea_object_version_number => l_pea_object_version_number
);

end;
/
commit;

-----

Cause

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