ETL9.X:TL_ST_Loader Running To Success But Not Placing Time In TL_RPTD_TIME

(Doc ID 2334217.1)

Last updated on DECEMBER 06, 2017

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 Reporting

ACTUAL BEHAVIOR
---------------
tl_st_Loader running to success but not placing time in TL_RPTD_TIME

Please call asap as we are needing time loaded for payroll. Integration Broker punched time goes to success and I see records in it. TL_ST_LOADER is kicking off and going to success, but no time is available in TL_RPTD_TIME. Please upgrade to priority 1 as we also need this time loaded in order to begin our upgrade move to production scheduled for today.

EXPECTED BEHAVIOR
-----------------------
TL_ST_LOADER should upload the punches

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. TCD send out punches via integration broker message which triggers TL_ST_LOADER
2. TL_ST_LOADER ran to success but it did not load data to tl_rptd_time from 11/30/2017 onwards, it loaded all prior data


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