Hr_sit_api.update_sit Is Not Updatng (Doc ID 2562624.1)

Last updated on SEPTEMBER 08, 2022

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
When updating SIT by using below api it is not updating the SIT

Following is the sample code

hr_sit_api.update_sit.
Below is the sample code:
declare
p_per_object_version_number number:=1;
p_analysis_criteria_id number:=12345;
n_segment1 varchar2(50) := 22;
begin
hr_sit_api.update_sit
  (p_validate => FALSE,
  p_person_analysis_id => 1234,
  p_pea_object_version_number => p_per_object_version_number,
  p_date_from => TRUNC (SYSDATE),
  p_segment5 => n_segment1,
  p_analysis_criteria_id => p_analysis_criteria_id
  );
commit;
end;

EXPECTED BEHAVIOR
-----------------------
SIT should get updated.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the script using hr_sit_api.update_sit
2. Script is completed successfully
3. But SIT is not updated

Changes

Cause

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