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 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.

Goal

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.
 

Solution

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
Goal
Solution
References


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