ETL9.x: Reported Punch Totals From TCD Wrong/Blank.

(Doc ID 1986565.1)

Last updated on JANUARY 09, 2018

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.1 to 9.2 [Release 9]
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 a 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

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