Unable to Open User-Defined Reports That Are Generated in Excel Format

(Doc ID 2337214.1)

Last updated on JANUARY 11, 2018

Applies to:

Primavera Unifier Cloud Service - Version N/A and later
Primavera Unifier - Version 9.13 and later
Information in this document applies to any platform.

Symptoms

On Unifier: Any Version - with some versions of Excel

ACTUAL BEHAVIOR
----------------------
Users are unable to run User-Defined Reports (UDRs) in EXCEL format. Other formats are working successfully (pdf, html, etc). Also, when the Excel file is opened using AutoVue viewer, the content shows as tag-filled gibberish.

STEPS TO REPRODUCE
----------------------

  1. Login into Unifier
  2. Navigate to some work space where a UDR exists and open the item
  3. Select Report Format as ‘Excel’
  4. Click on ‘RUN’
  5. When the process completes Save the report and then try to open it with Excel. Notice that Excel returns: The file you are trying to open is in a different format that specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?
  6. Disregard this, click on the Yes button, and notice the report opens and returns data as expected.
  7. Now try opening the same saved report through AutoVue and notice that the data is returned as tag-filled gibberish.



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