My Oracle Support Banner

PS_EMPLMT_SRCH_QRY Security View Performance Issue Due to High Data Volume (Doc ID 1266347.1)

Last updated on NOVEMBER 10, 2019

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
***Checked for relevance on 01-Apr-2014***

Symptoms

HCM 9.1 PS_EMPLMT_SRCH_QRY security view performance issue due to very large data volume (e.g. greater than 300,000 employees). 
 

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


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