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.
On : 22.214.171.124.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.
Before started after applying October-2020 OBI Bundle Patch 31690029
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