ETL9.2: Performance Issue With Fluid/PUM Upgrade For TL_Timeadmin
(Doc ID 2559911.1)
Last updated on AUGUST 28, 2023
Applies to:
PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
On : 9.2 version, Technical
ACTUAL BEHAVIOR
---------------
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
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Time administration
2. There is performance delay
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 |
| Cause |
| Solution |
| References |