My Oracle Support Banner

Report Subtotals And Totals Does Not Work When Items in Numeric Column is Null (Doc ID 2787486.1)

Last updated on SEPTEMBER 05, 2021

Applies to:

BI Publisher (formerly XML Publisher) - Version 12c and later
Information in this document applies to any platform.

Symptoms

On : 12.2.1.3.0 

Reports which had working subtotals and totals now only work if all items in the numeric column are not null.

The issue can be reproduced at will with the following steps:
1. Create a report having SUM as formula to sum all values of a numeric column.
2. Datasource for the report should include numeric column with null values
3. subtotals and totals are blank when having record with null values in the numeric column.

Changes

 Before started after applying October-2020 OBI Bundle Patch 31690029

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
Changes
Cause
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.