My Oracle Support Banner

Classic Position Data Record REPORTS_TO Field is not Getting Updated Correctly When Deleting an Effective Sequence Row from the Fluid Manage Positions (Doc ID 2862080.1)

Last updated on APRIL 12, 2022

Applies to:

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

Symptoms

The classic position data record PS_POSITION_DATA is not getting updated correctly with REPORTS_TO field when deleting an effective sequence row from the Fluid Manage Positions.


The issue can be reproduced at will with the following steps:
1. Create a new position number
2. Leave REPORTS_TO field blank
3. Validate records PS_POSITION_DATA_E and PS_POSITION_DATA
4. Add a new effective sequence with the same position number
5. Populate the REPORTS_TO field
6. Validate records. Both records are in sync.
select * from ps_position_data_e where position_nbr = 'xxxx'
select * from ps_position_data where position_nbr = 'xxxx'
7. Delete the added effective sequence row from fluid position.
8. Validate records. REPORTS_TO field is not BLANK.
select * from ps_position_data_e where position_nbr = 'xxxx'
select * from ps_position_data where position_nbr = 'xxxx' 

Changes

 

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
Changes
Cause
Solution
References


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