My Oracle Support Banner

Performance Issue On PERWSQHM When Using SSN Or Employee # To Query Person (Doc ID 2297881.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle Human Resources - Version 12.2 HRMS RUP6 and later
Information in this document applies to any platform.
New code added for 12.2.8


Slow Performance when querying by employee number, however searching by Last Name or wildcards takes only 1-2 seconds

Expect to query and have results within 1-5 seconds when querying by employee number, or Lase Name or Wildcards

Step to Reproduce:
The issue can be reproduced at will with the following steps:

Open the Find Person window created with the People Management template and query on employee number


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

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