My Oracle Support Banner

R12: How To Create A Link To A Discoverer Workbook (Doc ID 471303.1)

Last updated on AUGUST 02, 2018

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.0 to 12.1.3 [Release 12.0 to 12.1]
Oracle Application Object Library - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Business Intelligence Server Enterprise Edition - Version to [Release 12c]
Information in this document applies to any platform.
*** Checked for relevance on 19-Jan-2017 ***


To create a link from the Oracle Applications R12 home page to a Discoverer workbook that will automatically open Discoverer Plus or Viewer and display the workbook using apps security.

OracleOASIS.RunDiscoverer function is written in plsql.  However plsql is no longer supported in R12.  Therefore OracleOASIS.RunDiscoverer has been re-written as OracleOasis.jsp.  

Please Note: This technique has not been tested extensively, however initial tests indicates that it works correctly. 

This information is provided as is for the convenience of customers however, as this technique involves calling undocumented APIs (OracleOasis.jsp), it is not officially supported by Oracle Support or Oracle Development. As such, while support will endeavor to assist customers encountering issues while following the steps documented herein, these will be on a best effort basis efforts will not be subject to usual support service level agreements regarding response times, escalations, etc. 

If you encounter any problems following this process the first step in troubleshooting is to ensure that you are able to access the seeded workbooks delivered with eBusiness Suite. To this end please follow the instructions in metalink Note 373634.1 "Using Discoverer 10.1.2 with Oracle E-Business Suite Release 12" which will provide a fully supported environment to troubleshoot issues which are not due to the customizations performed here.

Please ensure that you understand the support implications before implementing these steps.


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.