My Oracle Support Banner

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.

Goal

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 11.1.1.7.150120, but the fix was not ported to the newer releases for Cloud SaaS customers.

Solution

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
Goal
Solution
References


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