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

Last updated on JUNE 21, 2023

Applies to:

Symptoms

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.

EXPLANATION:
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:

EFFDT EMPL_RCD EFFSEQ
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.

Cause

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