E-QR: Query With Prompts Run To HTML When Using Run To Excel Link (Doc ID 1570670.1)

Last updated on NOVEMBER 30, 2015

Applies to:

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

Symptoms

Query with prompts are running to HTML when Run to Excel link is used.

1. Login to PIA
2. Navigate to Query Manager/Query Viewer
3. Search by a query with prompts
4. Click on Run Query To Excel link
5. Enter the prompt value
6. Hit Enter key
7. The results are displayed in HTML instead of opening the MS Excel window

It will export the results to Excel correctly only if the "View Result" button is clicked.

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