E-QR: Download Query To Excel throwing "Authorization error - Contact your Security Administrator" (Doc ID 662388.1)

Last updated on JANUARY 31, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.4 and later
Information in this document applies to any platform.
SPECIFIC TO: Enterprise, Query Manager, Download to Excel

***Checked for relevance on 21-Mar-2013***
***Checked for relevance on 31-Jan-2017***


Symptoms

When trying to download the query result to Excel, receive error: "Authorization error - contact your security administrator".

This is affecting all queries and all users. The user permissions have been checked and are correct as per requirements (check the permission list for WEBLIB_QUERY and PTPT1200).

When the error occurs, the address shown in the URL of the error page shows that PeopleSoft is trying to write the Excel file to is a strange location, (ie, in one instance, it is pointing to a Word document on a specific user's personal folder. This folder is on customer's network, but not on the PeopleSoft file server or web server.)

The correct URL should be something like this:
http://domainname.com:8034/psc/E881GXTP/EMPLOYEE/ERP/s/WEBLIB_QUERY.ISCRIPT1.FieldFormula.IScript_ToExcel/?47XRFWIN

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