Performance Issue On Employee Search And Maintain Screen After Applying Patch 14175573:R12.PER.B
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:
- Log as HRMS Manager responsibility
- Navigate to ->Enter and Maintain
- 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