My Oracle Support Banner

Blank Columns In Report Are Filled With Incorrect Data (Doc ID 2541926.1)

Last updated on SEPTEMBER 16, 2019

Applies to:

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

Symptoms

On : Oracle BI Publisher release 12.2.1.x

ACTUAL BEHAVIOR
----------------------------

BI Publisher fills blank columns of table in a report with incorrect values.

EXPECTED BEHAVIOR
---------------------------------
The blank columns of table in a report should be left as it is. Should not fill with incorrect information.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create a data model with 4 data sets. Each data set uses SQL queries that use 'Union All' operator.
2. View data from data model and it shows correct XML data.
3. But the report shows incorrect values for blank columns.



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