E-QR: Download Query To Excel throwing "Authorization error - Contact your Security Administrator"
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***
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:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms