E-QR: Performance Issues With Date Fields in Query Excel Output With PeopleTools 8.55 (Doc ID 2269922.1)

Last updated on MAY 31, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 to 8.55 [Release 8.4]
Information in this document applies to any platform.

Symptoms

After upgrading to PeopleTools 8.55.12 - 8.55.15, performance issues are seen when downloading Excel output for queries from Query Manager.  This is also reported to occur in some cases for scheduled queries as well.
 
These performance issues are specific to queries with date fields, taking much longer time to run.  When downloading from Query Manager it may timeout and not download at all.

In removing the date fields from the queries and running again, the performance issue is not present and query results are ready in the expected amount of time.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms