How To Run SQL From A Discoverer Applications Mode Workbook In SQL*PLUS (SQLPLUS) To Troubleshoot Performance And Worksheet Results (Doc ID 279736.1)

Last updated on JULY 20, 2016

Applies to:

Oracle Discoverer - Version 4.1.48.08 to 11.1.1.4.0 [Release 4.1 to 11g]
Information in this document applies to any platform.
***Checked for relevance on 19-Dec-2013***

Oracle e-Business Suite 11.5.X
Oracle e-Business Suite 12i


Goal

To provide the steps necessary to be able to run SQL generated by Discoverer worksheet in an Application Mode EUL in SQL*Plus (SQLPlus).

This may be necessary to compare results, check performance, check for the return of data outside of Oracle BI Discoverer in a consistent and comparable manner eliminating specific Discoverer query governor features.

This document is relevant to E-Business Suite 11i and 12i; however, you may need to set additional context (i.e. - a specific organization, if multi-org is configured, or HR Security Groups) for data to return.

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