My Oracle Support Banner

OBIEE 12c: Direct Database Request Report does not Show Correct Number of Rows (Doc ID 2699242.1)

Last updated on NOVEMBER 04, 2024

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 (DDR). The Table view has a Sections field. When changing the layout and moving 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.