ETL8.9 & 9.0: Performance Problem at TL_PUB_TM1.ACCT_DT.Step05 (SQL)
(Doc ID 650024.1)
Last updated on JULY 22, 2020
Applies to:PeopleSoft Enterprise HCM Time and Labor - Version 8.9 and later
PeopleSoft Enterprise HCM Pay/Bill Management - Version 8.9 and later
Information in this document applies to any platform.
This document was previously published as Customer Connection Solution 201021698
Customer notices performance problem at TL_PUB_TM1.ACCT_DT.Step05 (SQL). Incident ID: 1368566000 was reported and resolved in Bundle #8. It reduced the number of joined tables from 4 to 3. Customer applied the fix but still notices performance issues. They added two update statistics steps before TL_PUB_TM1.ACCT_DT.Step05 for the table: TL_ACCTDT_WRK and WRK_PROJ2_TAO and noticed huge improvement. Performance went from 7 hours to 2 hours. App. Engine traces before and after the change are attached.
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