My Oracle Support Banner

After Database Upgrade to Oracle Database 19c, Performance Issues with Peoplesoft Complex Queries (Doc ID 2744611.1)

Last updated on DECEMBER 20, 2023

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


After Database Upgrade to Oracle 19c, performance issues with Peoplesoft Complex queries that use security views, PS_EMPLMT_SRCH_QRY and PS_PERALL_SEC_QRY. 
For example, some custom queries are taking very long time to run and other keep running, endlessly. 

Steps to Replicate Issue:

1. Create custom Query using PS_JOB that automatically joins PS_EMPLMT_SRCH
2. Upgrade Peopletools 8.58.04 and Oracle Database 19c
3. Run the custom Query again, no longer runs with no errors.




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

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