My Oracle Support Banner

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 and later
Information in this document applies to any platform.


 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.




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

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