Slowness / Performance Issue while Creating or Updating Employee in People Form (PERWSHRG)
(Doc ID 2765783.1)
Last updated on AUGUST 14, 2023
Applies to:
Oracle HRMS (Mexico) - Version 12.2 HRMS RUP13 and laterInformation in this document applies to any platform.
Symptoms
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.
Steps :
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
or
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.
Cause
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
Symptoms |
Cause |
Solution |
References |