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:

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

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