ETL 9.2 : Time Admin Performance Issue At TL_TA001300.DA000.STEP070 (Doc ID 1902302.1)

Last updated on MAY 09, 2016

Applies to:

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

Symptoms

ETL 9.2 : Time Admin Performance Issue at TL_TA001300.DA000.Step07.0 When running Time Admin process for full organization (around 48,000 employees), time admin process took around 8 hours to complete TL_TA001300program (Update ECD and TR Status), more specifically its taking most of the time in "TL_TA001300 SECTION: DA000 STEP: Step070 ACTION: SQL" step.

We have run the time admin process for around 400+ employees in dev environment. It took around 21 minutes to complete the "TL_TA001300.DA000.Step070" step.
Trace file is attached

REPLICATION STEPS
=================
1) Run time admin for a group.
2) Time admin is stuck at TL_TA001300.DA000.Step070 for a long time

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