My Oracle Support Banner

ETL9.2: Issue With Overtime Calculation Due Wrongly Resetting ECD On TL_TR_STATUS. (Doc ID 2535824.1)

Last updated on OCTOBER 03, 2023

Applies to:

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


The System not setting the ECD (Table PS_TL_TR_STATUS) to the last day of the month (and year) when the day being the first day of the work week (Monday)
which is a holiday and when the employee punches any day after the first day during the work week.

When a positive time reporter punches on the day other than the Monday, the last day of the month, in the work week then the system sets ECD to the day of the punch.

This became critical when Company has 2 weeks of holidays and the time administration process doesn't calculate the Overtime Straight for the week in question.


- The Company closed from December 19, 2018 to January 1, 2019 after running the payroll for the pay period ending 12/31/2018. The overtime period is Monday to Sunday and Monday happens to fall on the last day of the year 12/31/2018.
- The positive reporter, who comes back on either Jan 2, 2019 or later in that week, punches the time and the ECD = 1/1/19.
- The time administration process does not consider the Holiday hours of Monday during that work week to calculate the Overtime and hence the Employees miss the Overtime payable time.
- When the ECD reset to 12/31/2018, Time Administration process creates the overtime payable time correctly.


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.