My Oracle Support Banner

ETL9.2: Performance Issue With Fluid/PUM Upgrade For TL_Timeadmin (Doc ID 2559911.1)

Last updated on JULY 01, 2019

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.