Fusion Benefits: DBI Item PER_PER_LATEST_REHIRE_DATE Not Returning the Latest Rehire Date
(Doc ID 2671012.1)
Last updated on MAY 15, 2020
Applies to:Oracle Fusion Benefits Cloud Service - Version 11.13.20.04.0 and later
Information in this document applies to any platform.
On : 11.13.20.04.0 version, Fast Formula - Benefits
DBI Item PER_PER_LATEST_REHIRE_DATE 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.
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