My Oracle Support Banner

Performance Issues with Query Security Records (Doc ID 654046.1)

Last updated on FEBRUARY 08, 2019

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


***Checked for relevance on 14-Nov-2013***


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.