My Oracle Support Banner

ETL9.1: TL Load With FLSA On Causes Earnings Begin-End Dates For Prior Period Cross Pay Period End Dates (Doc ID 1474998.1)

Last updated on MARCH 02, 2020

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.1 and later
Information in this document applies to any platform.


HRMS 9.1 Bundle 8

It appears when FLSA is turned on for semi monthly payroll, sometimes the pay earnings begin and end dates on a prior period cross over the pay period end dates. This causes a problem because when you have 10, 11 or 12 day pay periods so the rate could be different. The pattern is if the employee has no job row, or has a job row but no payline impact within the week of the prior period it will load incorrectly. Employees that have a job row with payline impact will create the correct earnings end date. Also if the prior period is within the same month it is loaded correctly.

Steps to Recreate:
1.Make sure Process Prior Paygroup is not selected on TL_INSTALLATION table
2.Select two different semimonthly paygroups with same pay period end dates and both with FLSA turned on. Pay calendar period for this scenario is 5/16/12 – 5/31/12.
3.Select two salaried EEs one in each of the two paygroups above
4.Both EE are assigned to a workgroup that requires no approvals.
5.For only one EE make a job data change effdt 5/01/12 to change the department only. Make sure there is no paygroup change.
6.For the second EE no job data change is done
7.For both EEs enter 8 hours VAC on 4/30/12 (this is for a prior period).
8.Run Time Admin for the two employees with process date of 5/31/12.
9.Create paysheets for both paygroups for 5/31/12 pay period end date.
10.Load TL to Payroll for both paygroups
11.Review Payline for data loaded from TL. Compare pay begin and end dates for EE with job change is different than employee with no job change.

Business Impact:
This causes a problem because when you have 10, 11 or 12 day pay periods so the rate could be different.




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.