Performance Issues with Row-Level Security Joins Applied with PS_PERALL_SEC_QRY
Last updated on DECEMBER 21, 2015
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';
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