Replace Null Value with Zero In Pivot PDF and HTML Reports
(Doc ID 2518574.1)
Last updated on FEBRUARY 02, 2020
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 11.13.19.01.0 and later
Information in this document applies to any platform.
BI Publisher successfully generates 0 for null values in Interactive output, but the pivot table displays a blank/null leaves a null value for other output formats (HTML and PDF).
We would like the ability to be able to display a zero 0 when the number is blank, null or missing when pivot table output formats such as HTML and PDF.
The pivot tables would be cleaner if there was a zero in the field, rather than a blank, which is the standard for an Excel pivot table.
This issue was addressed in bug 20704282 for EBS and fixed in BI Publisher 18.104.22.168.150120, but the fix was not ported to the newer releases for Cloud SaaS customers.
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