My Oracle Support Banner

Performance Issues with Query Security Records (Doc ID 654046.1)

Last updated on APRIL 11, 2024

Applies to:

PeopleSoft Enterprise HCM Resume Processing - Version 8.8 to 8.8 SP1 [Release 8.8]
PeopleSoft Enterprise HCM Human Resources - Version 8.9 to 9 [Release 8.9 to 9]
PeopleSoft Enterprise HCM eCompensation Manager Desktop - Version 8.9 to 9 [Release 8.9 to 9]
PeopleSoft Enterprise HCM eCompensation - Version 8.9 to 9 [Release 8.9 to 9]
PeopleSoft Enterprise HCM Candidate Gateway - Version 8.9 to 9 [Release 8.9 to 9]
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 201039058



Symptoms

Queries containing the security records PS_PERS_SRCH_QRY AND PS_EMPLMT_SRCH_QRY are experiencing slow performance.

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.