Performance Issues with Query Security Records (Doc ID 654046.1)

Last updated on JULY 25, 2016

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms