E-BI/XMLP: BI Publisher 11.1.1.6 Output Columns Are Not Resized (Widened) (Doc ID 1573701.1)

Last updated on MAY 23, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.
*** Checked for relevance on May 2015 ***

Symptoms

When attempting to view BI Publisher Reports in BI Publisher 11.1.1.6 the columns of HTML. PDF, RTF, XLSX outputs from an RTF layout template do not get re-sized (widened) as they did in previous BI Publisher versions. The same issue may be reproduced on Oracle BI Publisher Desktop (v. 11.1.1.6).

The only exception is with XLS output - this is not an issue.

Steps

The issue can be reproduced at will with the following steps:

1. Login to PIA

2. Navigate to Reporting Tools > BI Publisher > Data Source

3. Create a new data source

4. Upload the sample xml file

5. Navigate to Reporting Tools > BI Publisher > Report Definition

6. Create a new Report Definition

7. Upload the rtf template

8. Go to Output tab and set by default xls

9. Navigate to Reporting Tools > BI Publisher > Setup > Global Properties

9.1. Select the Property Group PeopleTools Settings
9.2. Change the value for the setting psxp_excel_outputformat to xlsx (Property Group: PeopleTools Settings)

Note: The same settings may be setup individually for each report from Reporting Tools > BI Publisher > Report Definition – Properties tab

10. Click on Preview tab - the file should be opened with xlsx in order to reproduced the issue
Note: If the File Download window pop-up the file name with xls extension the issue may be not reproduced
However, the only exception when the issue does not reproduce is with xls output, the psxp_excel_outputformat is setup to XLS-MHTML (Reporting Tools > BI Publisher > Report Definition – Properties tab – Property Group: PeopleTools Settings )

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