My Oracle Support Banner

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

Last updated on JANUARY 26, 2024

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

 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 12.2.0.1

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?

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.