E-QR/NV Download to Excel Rounding to Six decimal places in the Resulting .xls File.

(Doc ID 2097221.1)

Last updated on AUGUST 10, 2016

Applies to:

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


On prior tools version (eg. 8.50), users were able to export the results of queries from Query Manager and decimal points were represented past 6 decimal places in the resulting Excel file.

After upgrading to PT 8.54.13, the same export process now rounds the decimal positions to 6 decimal places and fills zeros after the 6th decimal position.

e.g. 0.12345678 becomes 0.12345700


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