E-QR: Query To Excel Data Does Not Fit Within Default Column Width (Doc ID 2142784.1)

Last updated on FEBRUARY 08, 2021

Applies to:

Symptoms

The content cells are stretched in the downloaded excel, so the entire content of the cells is not shown. The width is the width of the column label.

The issue can be reproduced with the following steps:
1. Login to PIA
2. Navigate to Reporting Tools > Query > Query Manager
3. Create a new PS Query (e.g. SB_TEST_AUTOFIT)
4. View Query SQL:
SELECT A.BUSINESS_UNIT, A.VOUCHER_ID, TO_CHAR(A.ACCOUNTING_DT,'YYYY-MM-DD'), A.VCHR_BAL_ERR_FLG
 FROM PS_VOUCHER A
5. Hit Run tab
6. Download the results to Excel(xlsX) - The column width does not Autofit properly.

Changes

This is currently working as designed. Auto width format was removed in PT 8.57 and back ported to PT 8.56.09. The changes were applied due to the new technology 'Apache API' used by PS Query.

Cause

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