Slowness / Performance Issue while Creating or Updating Employee in People Form (PERWSHRG)
(Doc ID 2765783.1)
Last updated on APRIL 07, 2021
Applies to:Oracle HRMS (Mexico) - Version 12.2 HRMS RUP13 and later
Information in this document applies to any platform.
12.2.4 version, HR_PF.C.Delta.13 Performance PERWSHRG
Actual Behavior :
Seeing a performance hit in Instance when attempting to save new employees or update existing employees.
Expected Behavior :
It is expected to save within a minute or few seconds.
The issue reproduced with the following steps:
1. Login with Mexico HRMS Manager Responsibility
2. Navigate to the Function People > Enter and Maintain
3. In this form, try to enter New employee Details and Save
4. Try to query existing employee in the same form , Edit any of the information and Update.
Both takes more time to Save.
While generating TKPROF on SQL trace , we found the below two queries that were taking more time.
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