My Oracle Support Banner

Standard Hours for FMLA Eligibility will not Calculate in Certain Situations (Doc ID 634907.1)

Last updated on JUNE 21, 2023

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 8.8 SP1 and later
Information in this document applies to any platform.


In Funclib_fmla.std_hours fieldformula view fmla_job_vw is used.  It doesn't work when empl_rcd 0 and empl_rcd 1 have the same effdt and one of the empl_rcd's also has an effseq > 0.  

The row with an effseq > 0 is returned the other row isn't returned.  The std_hours is not calculated correctly in this instance.

Under a very narrow set of circumstances, the Eligibility and Entitlement pushbutton will result in the return of incorrect information for standard hours because the FMLA_JOB_VW max(effseq) select doesn't specify the empl_rcd in the join. Because of this, the data returned will be incorrect for the following set of JOB rows:

08/01/04 0 0
08/05/04 0 0
08/05/04 0 1
08/05/04 1 0

In the above scenario, the data for the row in which EMPL_RCD = 1 will not be returned by the view, and the calculation will be incorrect.


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.