My Oracle Support Banner

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

Last updated on FEBRUARY 01, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.


When attempting to view BI Publisher Reports in BI Publisher 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.

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


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 )




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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