My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Symptoms
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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