My Oracle Support Banner

Fluid Position Management : Incorrect Values In POS_LABEL_ID Column In POSITION_CH_DAT (Doc ID 2573195.1)

Last updated on AUGUST 02, 2019

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.



The values in POS_LABEL_ID column in POSITION_CH_DAT are not populated correctly when new row is added in Fluid Management Position data.

Correct label ids should be used according to the descriptions

The issue can be reproduced at will with the following steps:
Steps to recreate the issue:
step 1: Workforce Administrator -> Position Management -> Manage Position -> search for position
Step 2: Click on the position and click to add a new row
Step 3: Update the position ( for example, by updating the reports to or title) and follow the Activity Guide steps to view the last step - Review and Submit. Take a note of the values on the Summary of Changes table. Submit the position.
Step 4: Run SQL code to view the values on this table:

select * from PS_POSITION_CH_DAT where POSITION_NBR = 'position#';

POS_LABEL_ID column is not being used to display the values on the Review and Submit page, however the values on this column are not populated correctly.


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

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