Performance Issue On Employee Search And Maintain Screen After Applying Patch 14175573:R12.PER.B

(Doc ID 1501889.1)

Last updated on FEBRUARY 09, 2018

Applies to:

Oracle Human Resources - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

This note provides a brief overview of Bug 14175573


While searching for employees on enter and maintain screen its taking upto 2 mins to return the result..We did a form trace with binds variable and found out that oracle internal query is itself taking upto 42 secs...
Steps to Reproduce the Issue:

  1. Log as HRMS Manager responsibility
  2. Navigate to ->Enter and Maintain
  3. Search the employee either by full name or employee number

The application takes up to 2-3 mins   to return the person record first time, on subsequent similar searches it returns the result faster.However if you log out from application and try again in a new session or restart your machine and try it again taking up to 2-3 mins on search on enter and maintain screen.




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