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

Last updated on JANUARY 03, 2023

Applies to:

Symptoms

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

Cause

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