OBIEE 12c DV Report Showing Incorrect Results (Doc ID 2589720.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Symptoms

Report in Data Visualization is showing incorrect values for a row, which causes incorrect totals as well.

When an additional column is added to the report, then the values for the row change and are correct, as well as, the totals are then correct.

Should see the correct values even with just 2 columns selected, and should not have to add the 3rd column to get the correct results.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Access the Project report with just two columns and see the incorrect values, as well as the incorrect totals for that section.
2. Add another column to the report, and now see the values change, as well as the totals. The values and totals are now correct.
 

Cause

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