E-PIA: PT 8.59.22, PT 8.60.10 & PT 8.60.11 Download To Excel File on Grid Pages is Displaying Incorrect Amount For Example, 120,000.00 is Showing as 120.000 (Doc ID 3002845.1)

Last updated on SEPTEMBER 30, 2024

Applies to:

Symptoms

The downloaded Excel file on any grid page is showing incorrect values.

USE CASE 1
==========
The first comma (digit separator) is displayed as a decimal point in Excel and the values after the first comma are displayed as three zeros. For example: an amount of 120,000.00 is downloaded as 120.000.

USE CASE 2
==========
If there is a currency symbol in the grid, the downloaded value in Excel is 0.

For example, it can be reproduced with the following steps:

1. Navigate to Commitment Control > Review Budget Activities > Budgets Overview.
2. Create a new Search Inquiry using the Add a New Value button.
3. Enter Inquiry name.
4. Click Search.
5. On the Budget Inquiry Criteria page, populate the data.
6. Click Search at the top left of the page, this will load the Inquiry Results.
7. On the grid, click the Download to Excel button. Notice that the amount is incorrect.

Changes

Applying PeopleTools patches: PT 8.59.22, PT 8.60.10 & PT 8.60.11.

Cause

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