Fusion Benefits: DBI Item PER_PER_LATEST_REHIRE_DATE Not Returning the Latest Rehire Date
(Doc ID 2671012.1)
Last updated on OCTOBER 16, 2023
Applies to:
Oracle Fusion Benefits Cloud Service - Version 11.13.20.04.0 and laterInformation in this document applies to any platform.
Symptoms
DBI Item PER_PER_LATEST_REHIRE_DATE is not returning Latest Rehire Date.
We have a fast formula that uses the value PER_PER_LATEST_REHIRE_DATE as a comparison to return only assignment records on or after that date. However, it is returning the wrong date when in use for an employee with multiple periods of service.
e.g The employee has one period of service running from 01-Jul-2007 through 03-May-2015 and then a second period of service starting on 04-May-2015 to current.
When the formula is run for this person, PER_PER_LATEST_REHIRE_DATE is returning a value of 01-Jul-2007 and not the date of 04-May-2015.
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 |