Even After Set Zero Values/No Data/Error To "-" In FRS Still Shows 0 In Excel
(Doc ID 2849584.1)
Last updated on MARCH 27, 2023
Applies to:
Oracle Fusion General Ledger Cloud Service - Version 11.13.20.10.0 and laterInformation in this document applies to any platform.
Symptoms
On : 11.13.20.10.0 version, GL Reports & Inquire Screens
ACTUAL BEHAVIOR
---------------
When setting suppression for Zero Values, No Data and Error as "-" and exporting the report to excel, the data is correct but some cells with no values do not show the same and consistent use of "-" as the pdf export of the same report does.
EXPECTED BEHAVIOR
-----------------------
All cells with no data, or 0 or error should show "-" in both pdf and excel format
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. On an FRS report that shows all data correctly, setup suppression as below:
Zero Values -
No Data -
Error -
2. Run the report
3. Export to excel and pfd, some cells shows inconsistent formatting
f.e. the report shows balances as below for 6 different periods:
- pdf
409040- ABC Account (950) - 700 - 240 -
- Excel
409040- ABC Account (950) (0) 700 0 240 -
in excel not all cells shows as -, in some cases shows (0) or 0, the formatting is not consistent
Cause
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
Symptoms |
Cause |
Solution |
References |