Standard Hours for FMLA Eligibility will not Calculate in Certain Situations
Last updated on DECEMBER 13, 2017
Applies to:PeopleSoft Enterprise HRMS 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:
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms