HR_SIT_API.UPDATE_SIT is Not Updating Values and Completes with No Error (Doc ID 277525.1)

Last updated on FEBRUARY 05, 2024

Applies to:

Symptoms

HR_SIT_API.UPDATE_SIT is not updating values and completes with no error.

DECLARE
l_person_analysis_id PER_PERSON_ANALYSES.PERSON_ANALYSIS_ID%TYPE;
l_analysis_criteria_id PER_PERSON_ANALYSES.ANALYSIS_CRITERIA_ID%TYPE;
l_pea_object_version_number PER_PERSON_ANALYSES.OBJECT_VERSION_NUMBER%TYPE;
BEGIN
l_person_analysis_id := &personAnalysisId;
l_analysis_criteria_id := 12345; -- if value assigned no values will not be applied
l_pea_object_version_number := &OVN;
hr_sit_api.update_sit(
p_person_analysis_id => l_person_analysis_id,
p_date_to => to_date('09-JUN-2004', 'dd-mon-yyyy'),
p_segment5 => &ValidValueSegment5,
p_segment6 => &ValidValueSegment6,
p_analysis_criteria_id => l_analysis_criteria_id,
p_pea_object_version_number => l_pea_object_version_number
);
END;

Cause

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