E-PPR: Download Grid is slow, keeps processing, or times out when grid has many rows of data (Doc ID 2038094.1)

Last updated on JANUARY 20, 2016

Applies to:

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

Symptoms

For a grid with many rows (such as 10,000+), the download grid feature to download grid data into a spreadsheet file is very slow, keeps processing, or even times out completely.

Replication:

1. Go to any page with a grid that has many rows (such as over 10,000)
2. Use the "Download Grid" button in the grid header to Download Grid to Excel as a xls spreadsheet
3. Process is either very slow, or the process is timed out

In one customer's scenario, a grid with 43337 rows was being downloaded.

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