My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

Applies to:

Oracle E-Business Intelligence - Version and later
Information in this document applies to any platform.


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.


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.