ETL9.2: Performance Issue With Fluid/PUM Upgrade For TL_Timeadmin
(Doc ID 2559911.1)
Last updated on JULY 22, 2020
Applies to:PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.
On : 9.2 version, Technical
Performance issue with Fluid/PUM upgrade for TL_Timeadmin
We have noticed a change in code for TL_Timeadmin that is causing some performance issues. Performance issue is caused by below code
DELETE FROM PS_HCSC_USTEP_ATRB WHERE EXISTS ( SELECT 'HUA' FROM PS_TL_APP_TMP2 T , PS_TL_APP_PAY_XRF X WHERE T.PROCESS_INSTANCE = 100000637 AND T.EMPLID = X.EMPLID AND T.EMPL_RCD = X.EMPL_RCD AND T.SEQ_NBR = X.SEQ_NBR AND PS_HCSC_USTEP_ATRB.EOAWTHREAD_ID = X.EOAWTHREAD_ID AND PS_HCSC_USTEP_ATRB.EOAWPRCS_ID = X.EOAWPRCS_ID AND PS_H
The issue can be reproduced at will with the following steps:
1. Run Time administration
2. There is performance delay
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