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

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 )

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.