My Oracle Support Banner

OBIEE 12c: Direct Database Request Report Does Not Show Correct Number Of Rows (Doc ID 2699242.1)

Last updated on AUGUST 10, 2020

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.4.0 and later
Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.0 and later
Oracle Exalytics Software - Version 2.0.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Direct Database Request report does not show correct number or rows

Have a report based in Direct Database Request. The Table view has a Sections field. When you change the layout and move a column to Section field ,DDR is not showing the results.

This worked fine in OBIEE 11g and 12.2.1.0

Steps to Reproduce:
1. Create a DDR report (Direct Database report) Using the below query

select table_name, tablespace_name, initial_extent, next_extent, degree from all_tables;


2. Click on the results tab.You can see the results correctly with the correct rows.




3. Edit the Table >> From the Layout >> Move the TABLESPACE_NAME column in to the Sections. It will show some less records.




4.In this test case >> In place of USERS place , it should display more than two records which is wrong




 

 

Changes

 Upgraded to 12.2.1.4

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.