Human Capital Management - EBS (MOSC)

MOSC Banner

HR_POSITION_API.UPDATE_POSITION doesn't affect on PER_POSITION_DEFINITIONS table

edited Aug 2, 2018 9:55AM in Human Capital Management - EBS (MOSC) 5 commentsAnswered

Hi All,

Following code is written to update invalid position names affecting NAME column in hr_all_positions_f table and SEGMENT 15 (Designation),SEGMENT 20 (Track) columns in PER_POSITION_DEFINITIONS table. This code works perfectly for updating names but it does not update segment 15 and segment 20 columns. Issue remain same even with updates Flex values. I'm highly appreciated if  anyone can give me some guidance to clarify my issue.

BEGIN

DECLARE

L_VALIDATE  BOOLEAN   :=   FALSE;

P_GRADES_VALUES BOOLEAN;

eit_p_position_name VARCHAR2(10000);

eit_object_version_number  number;

eit_p_position_definition_id    number;

l_start DATE;

l_end DATE;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center