My Oracle Support Banner

ETL9.x: Time Admin Reverses Time Paid In Prior Period When Punch Time Exception Occurs On First Day Of Next Period In Error (Doc ID 1965921.1)

Last updated on NOVEMBER 23, 2019

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.


We are having issues with payroll when an employee has a punch exception on the first day of the next pay period. See example below...

Pay Period 12/17/14 - 12/23/14
Punch Time In 3:48 PM
Punch Time Out 11:48 PM
Time Admin Runs 11:00 AM 12/24/14
Payroll Confirmed 3:00 pm 12/24/14 for Period Ending 12/23/14

Next Pay Period 12/24/14 - 12/30/14
Employee neglects to Punch In on 12/24/14 - no record type of punch in for 12/24/14 is in TL_RPTD_TIME
Punch Time Out 11:55 PM
Time Admin Runs 2:00 AM
An Exception is Created now because there is a punch out 12/23/14 11:48PM and punch out 12/24/14 11:55PM due to no punch in on 12/24/14
Time for 12/23/14 is reversed in payable time due to exception

Supervisor Manually Enters In punch for 12/24/14 of 3:00 PM
Time Admin Runs 4:00 PM
Exception is cleared up for 12/24/14 because there is now an in punch
Payable Time is created for 12/24/14
But the time that was reversed for prior period of 12/23/14 is not recreated.

Assuming the TL_TR_STATUS date does not get reset to 12/23/14 due to timing of time admin being run between activities. But how do we get the system to recreate the time for the date in the prior period because now it is trying to take those hours away on their next paycheck.

Example of what TL_PAYABLE_TIME does during this scenario

12/23/14 REG 8.00 (already paid 12/23/14 because time was paid before exception of two out punches is created)
12/23/14 REG 8.00- (being reversed due to exception of no punch in for pay pd ending 12/30/14)
12/24/14 REG 8.00 ( gets paid as normal pay pd ending 12/30/14 once exception is cleared up)

If it is realized in time, the work around is to make a change to 12/23/14 so the system will go back and recreate that time. Not always caught before employee is not paid correctly. How do we get the system to automatically pick up this time?


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.