My Oracle Support Banner

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 22, 2021

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information 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


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