You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Seniority Date Calculation does not look at the Effective Latest Change assignment row

Hello,

I hope for your advise how to best workaround this scenario.

What confuses the end users:
The two bold italic Seniority Dates in the table below.

Why this happens:
There are Furture Assingment records created with start date after 01.07.2025. These are created with Grade = Scientific level 1 because creation date is prior to Grade change the 01.07.2025.
Then, effective 01.07.2025, the Grade is updated = Scientific level 2.
The Future Assignment records (effective later than 01.07.2025) are updated with correct Grade = Scientific level 2. This becomes the Effective Latest Change=Yes row.

The Calculate Seniority program does not look at the row with Effective Latest Change = Yes only. Is that intended by Oracle or is it a bug ?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!