ETL9.2 TL_ST_LOADER Has Bug In SQLExec That Does Not Allow For Selection Of CLK Badg (Doc ID 2096007.1)

Last updated on OCTOBER 27, 2016

Applies to:

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

Symptoms

Time and Labor process TL_ST_LOADER does not pick up data from the badge when other badges has higher effective dated rows.
TCD should pick up all the badges.

STEPS
-----------------------

1. setup PUNCHED_TIME_ADD/ELAPSED_TIME_ADD
2. Create csv file with different badge no, it has badges that have higher effdt than the CLK badge, CLK badge has active employees data.
3. Run EOP_PUBLISH
4. it will kick TL_ST_LOADER
5. Review TL_RPTD_TIME those rows are not inserted into TL_RPTD_TIME

Due to this issue, TCD does not insert data with different badge for active EE.

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