Steps for Getting Page Source (Underlying SQL) for DBI Report (Doc ID 1326606.1)

Last updated on MAY 23, 2017

Applies to:

Oracle E-Business Intelligence - Version 11.5.10.0 to 12.1.2 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Goal

When there is a data discrepancy identified for a DBI report, then need to know the underlying sql statement for the report.  Also, need to compare to other DBI report which may be more accurate.  This would be helpful for Development or Support to diagnose and compare each sql statement to see why there are inconsistent values.

In this example, will compare 4 different views of the 'Fulfilled Performance Report' where the total booked value differs.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms