My Oracle Support Banner

Call To HR_SIT_API.create_sit Failing (Doc ID 2181576.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

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

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


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