My Oracle Support Banner

PERWSHRG People Form Poor Performance After Database Upgrade to 19C Due to Query Fetching Unrelated Contacts While Performing the Security Evaluation (Doc ID 2920530.1)

Last updated on JANUARY 16, 2023

Applies to:

Oracle Human Resources - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR  
---------------

While user is trying to access employee records trough PERWSHRG People form application is running slow.

 

EXPECTED BEHAVIOR
-----------------------
Expected that application will run in a timely manner.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. (N) HRMS Manager -> People form -> Enter and Maintain
2. Query for any employee and click on Find -> Records are displayed after around 4 minutes.

Changes

 Database upgrade to 19C

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
Changes
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.