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

Last updated on JANUARY 02, 2017

Applies to:

Oracle Human Resources - Version 11.5.7 to 11.5.10.2 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
pesitapi.pkh
pesitapi.pkb



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;

Changes

 

Cause

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 hundreds of Community platforms