E-QR: Query To Excel Data Does Not Fit Within Default Column Width
Last updated on OCTOBER 14, 2016
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms