Slow Performance on Search Pages Querying PS_EMPLMT_SRCH_GBL after Upgrading Database to 12.2.0.1
(Doc ID 2452177.1)
Last updated on JANUARY 26, 2024
Applies to:
PeopleSoft Enterprise HCM Human Resources - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
After upgrading database for PeopleSoft HCM 9.2 environment from Oracle DB Rel. 11.2.0.4 to 12.2.0.1, search queries that used to complete in a few seconds when the database was at Rel. 11.2.0.4, now takes minutes.
SELECT DISTINCT EMPLID,
EMPL_RCD,
NAME,
NAME_DISPLAY_SRCH,
LAST_NAME_SRCH,
SECOND_LAST_SRCH,
FIRST_NAME,
LAST_NAME,
SECOND_LAST_NAME,
NAME_AC,
MIDDLE_NAME
FROM PS_EMPLMT_SRCH_GBL
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
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |