Performance Issue With PS_EMPLMT_SRCH_GBL Security View When Used In PSQUERY
(Doc ID 2542167.1)
Last updated on JULY 22, 2020
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.
After upgrading to 18c PSQUERY involving PS_EMPLMT_SRCH_GBL view are taking very long. Also saw a few bugs mentioned on Support search.
2530787.1 Performance issues after upgrade PERS_SRCH_GBL, PERS_SRCH_QRY & EMPLMT_SRCH_GBL, regarding bug 28291640
2452177.1 Slow Performance on Search Pages Querying PS_EMPLMT_SRCH_GBL after Upgrading Database to 220.127.116.11
On doing some research we found that this view has a missing join condition between the PSOPRDEFN and PS_SJT_PERSON table. Not sure if they can really be joined or not. For testing sake I created another view with a join between those 2 tables using EMPLID (not sure if that is correct). But it greatly helped in bringing down the timing.
Wanted to check with Oracle if the two tables can be joined using EMPLID or not?
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