R12: How To Create A Link To A Discoverer Workbook

(Doc ID 471303.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle Applications 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]
Information in this document applies to any platform.
*** Checked for relevance on 19-Jan-2017 ***

Goal

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.  This means that the techniques documented in Note 278095.1 "How to Create a Link to a Discoverer Workbook in Apps11i" needs to be modified slightly to get it to work with R12.

The author wishes to acknowledge the work done by the author of Note 278095.1 which forms the basis of this note. The essential differences between the 11i implementation and the R12 implementation have been highlighted for ease of comparison.

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.

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