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

Last updated on MARCH 10, 2015

Applies to:

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

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms