E-QR: Query Download To Excel Sheet Name Is "1" And Should Be Named "Sheet1"

(Doc ID 2134825.1)

Last updated on MAY 06, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Information in this document applies to any platform.

Symptoms

When attempting to run PS Query to Excel from Query Viewer/Manager to Excel the generated file contains an Excel Sheet named "1" instead of "Sheet1".

Steps
--------
The issue can be reproduced at will with the following steps:
1. Login to PIA
2. Navigate to Reporting Tools > Query > Query Manager/Query Viewer
3. Run the Query to Excel - the Excel sheet is named as "1".


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