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 FEBRUARY 04, 2025

Applies to:

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

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