My Oracle Support Banner

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 later
Information 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


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