ETL9.1Reported Punch Totals From TCD Wrong/Blank. (Doc ID 1986565.1)

Last updated on AUGUST 12, 2016

Applies to:

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

Symptoms

On : 9.1 version, Time Administration,Reported time tl_quantity is wrong/blank for punches coming from tcd

For example, employee has:
SEQ_NBR DUR PUNCH_TYPE PUNCH_TIME
28201 2/5/2015 1 1/1/1900 6:58:40.000000 AM
93003 2/5/2015 2 1/1/1900 11:58:21.000000 AM
161706 2/5/2015 1 1/1/1900 12:29:53.000000 PM
252910 2/5/2015 2 1/1/1900 3:32:19.000000 PM
PUNCH TOTAL incorrectly shows 5 hours


Another example, employee has:
SEQ_NBR DUR PUNCH_TYPE PUNCH_TIME
70001 1/27/2015 1 1/1/1900 3:55:22.000000 PM
70603 1/27/2015 2 1/1/1900 8:01:39.000000 PM
74506 1/27/2015 1 1/1/1900 8:27:57.000000 PM
32202 1/28/2015 2 1/1/1900 12:31:15.000000 AM
70305 1/28/2015 1 1/1/1900 3:57:48.000000 PM
138509 1/28/2015 2 1/1/1900 8:00:50.000000 PM
209614 1/28/2015 1 1/1/1900 8:28:01.000000 PM
PUNCH TOTAL is blank and should be 6 hours for 1/28






STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.TL_ST_LOADER loads punches from tcd to TL_RPTD_TIME

2. Punch Total is blank or wrong on timesheet. However when submit or save button is hit on timesheet punch totals are populated correctly.
3. Run time admin, view payable time and no/wrong payable time got created

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, employee may not get paid on time as no payable time is getting created

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