ETL92: Reported Time Approval Slow Performance due to SQLs hard parse more than 2000 times
(Doc ID 2865774.1)
Last updated on APRIL 28, 2022
Applies to:PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
User is on HCM 9.2.33 experiencing slow performance when manager tries to click on the Reported Time transaction from the Action Centre the page is loading for more than 1.5 mins. The performance is very slow. Below is the SQL that appears to be causing the issue:
SELECT FILL.EMPLID,FILL.EMPL_RCD,FILL.EOAWDEFN_ID,FILL.PUNCH_TYPE,FILL.TRANSACTIONID,TO_CHAR(FILL.DUR,'YYYY-MM-DD'),FILL.TRC,FILL.EOPCIMAGE_ID,FILL.EOPCUSE_MAP_DIR FROM PS_TL_RPT_LNFL2_VW FILL , PS_TL_RPT_LNFL_VW XREF WHERE XREF.DUR = fill.DUR AND XREF.EMPLID = fill.EMPLID AND XREF.EMPL_RCD = fill.EMPL_RCD AND XREF.EOAWDEFN_ID = fill.EOAWDEFN_ID AND XREF.PUNCH_TYPE = fill.PUNCH_TYPE AND XREF.TRANSACTIONID = fill.TRANSACTIONID AND XREF.TRC = fill.TRC AND FILL.EMPLID = '234254' AND FILL.EMPL_RCD = 0 AND FILL.EOAWDEFN_ID = 'TLByPosMgmt' AND FILL.PUNCH_TYPE = '1' AND FILL.TRANSACTIONID = 1
PSAPPSRV.7700 (6070) 1-1320 19.50.00 74.796000 Cur#1.7700.PUM2TRN RC=0 Dur=0.000000 COM Stmt=SELECT 'X' FROM PSRECFIELD WHERE RECNAME = :1 AND FIELDNAME = :2
Steps to Recreate:
1. Manager tries to click on the Reported Time transaction from the Action Centre the above performance issue occurs at above statement provided.
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