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 and later
Business Intelligence Suite Enterprise Edition - Version and later
Oracle Exalytics Software - Version and later
Information in this document applies to any platform.


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

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




 Upgraded to


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

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