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

Last updated on DECEMBER 20, 2016

Applies to:

Oracle Human Resources - Version: 11.5.10.2 to 11.5.10.2 - Release: 11.5 to 11.5
Information in this document applies to any platform.
***Checked for relevance on 11-Jul-2011***

Symptoms

-- Problem Statement:
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

EXPECTED BEHAVIOR
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;
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 =12345


  BEGIN

io_name := 'XXXX.Database Administrator';


HR_POSITION_API.UPDATE_POSITION (
p_validate => l_validate
, p_datetrack_mode => l_datetrack_mode
, p_position_id => 88702 --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

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