Steps for Getting Page Source (Underlying SQL) for DBI Report
Last updated on MAY 23, 2017
Applies to:Oracle E-Business Intelligence - Version 22.214.171.124 to 12.1.2 [Release 11.5.10 to 12.1]
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.
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