My Oracle Support Banner

E-QR: Downloading PSQuery Output To Excel, Amount Field Is Rounded Off To Accommodate Only 15 Digits (Doc ID 2821888.1)

Last updated on NOVEMBER 18, 2021

Applies to:

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


On : 8.58 version, Query

When attempting to download PSQuery output to Excel, Amount fields is getting rounded off to accommodate only 15 digits in a cell.

Same result is from Schedule Query and Query Viewer.

Example: If number is 46019557296626.870 which is 17 digits, but excel can accommodate only 15 digits so rounding off to 46019557296626.9.

The issue can be reproduced at will with the following steps:
1) Log into the PIA.
2) Run the query in query manager.
3) Click on Download to Excel.
4) Open the Excel.
5) Compare the results in excel vs query manager page.


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.