My Oracle Support Banner

ETL8.81: Performance problem with TL_ST_LOADER at TL_TR0012904 Step 3 Do Select (Doc ID 652417.1)

Last updated on NOVEMBER 23, 2019

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 8.8 and later
PeopleSoft Enterprise HCM Pay/Bill Management - Version 8.9 and later
Information in this document applies to any platform.
Time and Labor 8.8 Sp1, Performance 8.8 Sp1

This document was previously published as Customer Connection Solution 201032234


***Checked for relevance on 11-Feb-2010***


Symptoms

Performance problem with TL_ST_LOADER at TL_TR0012904 Step 3 Do Select

Maintenance Pack 6 changed App Engine Program - TL_TR0012904 Step 3 Do Select.
PS_TL_ST_ELPTIME was removed to add PS_TL_RPTD_ELPTIME. SQL scans 5 million rows in PS_TL_RPTD_ELPTIME.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.