Performance Issues with Row-Level Security Joins Applied with PS_PERALL_SEC_QRY
(Doc ID 1991030.1)
Last updated on DECEMBER 16, 2020
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
The PeopleSoft-delivered security search record PS_PERALL_SEC_QRY, which is automatically joined on queries that include personal data, performs quite poorly. It takes 20 mins to fetch the data, when joining with payroll tables.
1. Login as User
2. Run the query SELECT COUNT(*) FROM PS_PERALL_SEC_QRY WHERE OPRID='Userid';
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