Slowness / Performance Issue while Creating or Updating Employee in People Form (PERWSHRG) (Doc ID 2765783.1)

Last updated on AUGUST 14, 2023

Applies to:

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

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