After Updating Position Using Update_Position Api the New Position Name Does Not Reflect (Doc ID 805762.1)

Last updated on AUGUST 14, 2023

Applies to:

Symptoms

On 11.5.10.2 in Test:

Find when trying to change position using HR_POSITION_API.UPDATE_POSITION API, it does not change  the name

Expect the position name to be changed

Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Execute the  following API sql script

DECLARE

l_org_id number;
l_org_name varchar2(75);
l_loc_id number;
l_job_id number;
l_job_name varchar2(75);
l_employee_number varchar2(75);
l_position varchar2(75);
l_validate boolean default false;
l_datetrack_mode varchar2(15) default 'CORRECTION';
o_valid_grades_changed_warning boolean;
o_effective_start_date date;
o_effective_end_date date;
io_position_definition_id number;
io_name varchar2(80);
io_object_version_number number;
l_effective_date date;
l_position_id number := 12345 ;  -- Please use the correct position_id to be used.
l_error_msg varchar2(500);

BEGIN
select object_version_number,
position_definition_id,
name
into io_object_version_number,
io_position_definition_id,
io_name
from hr_all_positions_f
where position_id = l_position_id ;


  BEGIN

io_name := 'XXXX.Database Administrator';


HR_POSITION_API.UPDATE_POSITION (
p_validate => l_validate
, p_datetrack_mode => l_datetrack_mode
, p_position_id => l_position_id
, p_effective_date => trunc(sysdate) --l_effective_date
, p_date_effective => trunc(sysdate)
, p_valid_grades_changed_warning => o_valid_grades_changed_warning
, p_effective_start_date => o_effective_start_date
, p_effective_end_date => o_effective_end_date
, p_position_definition_id => io_position_definition_id
, p_name => io_name
, p_object_version_number => io_object_version_number
, p_segment1 => 'XXXX'
, p_segment2 => 'Database Administrator'
, p_concat_segments => 'XXXX.Database Administrator'
);
    END;
END;

Script completes error free but no changes take place.

Cause

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