Adding Multiple Effective Sequence rows While Updating Incumbents Populates Incorrect ACTION And ACTION_REASON On JOB Page (Doc ID 2589470.1)

Last updated on JULY 21, 2023

Applies to:

Symptoms

While updating Incumbents, and adding multiple effective sequence rows on Position data, an incorrect ACTION and ACTION_REASON is being added to the new PS_JOB row.

The actions/action reasons between JOB and Position Data will need to be in sync.

The issue can be reproduced at will, following the below mentioned steps :

1. Find a position number assigned to an employee.

2. Navigate --> Click Workforce administrator-->Position Management--> Manage Position,Enter position Number,search

3. Add a new row. Submit and approve request. Observe Incumbent's job data.

3. Add EFFSEQ = 1 for the same EFFDT updated above, use a different action and action_reason than above. Update another piece of position data. Submit and approve request. Observe incumbent's job data.

4. Complete step #2 again, adding EFFSEQ = 2 using a different action and action_reason than above, updating other position data. Submit and approve request. Observe incumbent's job data. EFFSEQs 1 and 2 written to job via the update incumbent process will (inaccurately) show the ACTION and ACTION_REASON from effseq 0.  

Cause

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