ETL 9.2 : Time Admin Performance Issue At TL_TA001300.DA000.STEP070
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.
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
1) Run time admin for a group.
2) Time admin is stuck at TL_TA001300.DA000.Step070 for a long time
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