My Oracle Support Banner

Performance Issue With PS_EMPLMT_SRCH_GBL Security View When Used In PSQUERY (Doc ID 2542167.1)

Last updated on JUNE 22, 2022

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
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

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

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