Performance Issue On PERWSQHM When Using SSN Or Employee # To Query Person

(Doc ID 2297881.1)

Last updated on AUGUST 17, 2017

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


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