Slow Performance on Search Pages Querying PS_EMPLMT_SRCH_GBL after Upgrading Database to 220.127.116.11
(Doc ID 2452177.1)
Last updated on JANUARY 22, 2021
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.
After upgrading database for PeopleSoft HCM 9.2 environment from Oracle DB Rel. 18.104.22.168 to 22.214.171.124, search queries that used to complete in a few seconds when the database was at Rel. 126.96.36.199, now takes minutes.
SELECT DISTINCT EMPLID,
WHERE OPRID = :1 AND LAST_NAME_SRCH LIKE 'BROWN%'
ORDER BY LAST_NAME_SRCH, EMPLID, EMPL_RCD
The issue can be reproduced at will with the following steps:
1. Navigation: Main Menu > Payroll for North America > Employee Pay Data USA > Create Additional Pay
OR Navigate to any other PeopleSoft Search pages using PS_EMPLMT_SRCH_GBL
2. Enter Search Criteria and click 'Search'
3. Note page takes minutes to return results
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