Fluid Position - Update an Existing Position Row Inserting Row in Job Data When Approval is ON (Doc ID 2917573.1)

Last updated on MAY 29, 2023

Applies to:

Symptoms

In Fluid position without Approvals, if we update an existing row. It will just update the most recent row in PS_JOB.
However in fluid position with Approvals, it is adding another row in PS_JOB with higher effseq everytime an update was done in position data.


Steps to replicate the issue:
1. Make sure Approval Options is not selected in Position Management Installation.
Navigate to Set Up HCM--Install--Product Specific--Position Data Installation
2. Execute app engine POS_SYNC_FLU
(Navigate to PeopleTools > Process Scheduler > System Process Requests)
Sync Fluid Position Data (POS_SYNC_FLU): Synchronizes Position Management data to the fluid records.
3. Add new row with following details in Position Data setup.
Effdt: Jan 1, 2021
Reason: 'UPD'
Job Code: 110000
Reg/Temp: Regular
4. Make sure Update Incumbent is Checked/Yes in Budget Incumbents page and Submit the transaction.
5. Verify the Classic and Fluid position data records and data reflecting correctly.
Select * from PS_POSITION_DATA where POSITION_NBR='XXXXXX'
Select * from PS_POSITION_DATA_E where POSITION_NBR='XXXXXX'
6. Edit Jan 1, 2021 row.
7. Update the Job Code of effective date Jan 1, 2021 with following.
Job Code: 120000
Reg/Temp: Regular
Update Incumbent: Checked
8. Query the fluid/Classic position data record and PS_JOB.
Select * from PS_POSITION_DATA_E where POSITION_NBR='XXXXXX'
Select * from PS_POSITION_DATA where POSITION_NBR='XXXXXX'
Select * from PS_JOB where EMPLID='XXX'
9. Changes not reflecting correctly in classic position data record as well as in PS_JOB(However, this is not the issue we are reporting in this bug).
10. If singout and signin back then update the fluid position then changes are reflecting correctly in fluid/classic position records as well as in PS_JOB.
11. Observe that PS_JOB has 3 rows.
12. Now Make sure Approval Options is turned on in Position Management Installation and perform same steps from 3 to 11.
13. Login as Approver and approve the transaction when create a new position row. Observe no issue with data in all 3 records.
14. Login as Approver and approve the transaction after modifying the fluid position data.
15. Query the 3 records and observe the PS_JOB got inserted with effective seq 1 row instead of updating eff seq 0 row.

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.