Discoverer 10g with Oracle E-Business Suite Release 12

Using Discoverer 10.1.2 with Oracle E-Business Suite Release 12

1.Install Oracle Discoverer 10g Release 2 (10.1.2.0.2)
Pls See the post http://oracledbas.blogspot.com/2008/12/oracle-business-intelligence-discoverer.html
2.Configure Oracle Discoverer 10g Release 2 (10.1.2.0.2)

In the Discoverer10g $ORACLE_HOME/opmn/conf/opmn.xml file check the variable for FND_SECURE. This variable specifies the directory where Discoverer is trying to locate dbc files. By

default this is set to $ORACLE_HOME/discoverer/secure.

cat $ORACLE_HOME/opmn/conf/opmn.xml grep FND_SECURE
cd $ORACLE_HOME/discoverer
mkdir -p secure

3.Copy Database Connection file

Copy R12 Instance($FND_SECURE) to BI(Discover) $ORACLE_HOME/discoverer/secure

4.Update tnsnames.ora file

Add TNS (tnsnames.ora) Both R12 and BI(Discover) Check tnsping

5.In Oracle R12 Change xml in s_disco_url parameter
cd $INST_TOP/appl/admin
[applmgr@sys33 admin]$ cat VIS_sys33.xml grep s_disco_url
Change s_disco_url in your Discoverer url
After change Check
[applmgr@sys33 admin]$ cat VIS_sys33.xml grep s_disco_url
http://sys22.doyen.in:7777

6.Set Applications profile options in Oracle E-Business Suite

Log into E-Business Suite Release 12 with the System Administrator responsibility
Navigate to the Profile > System form
Query the %Discoverer% profile options.

7.Regenerate your Business Views

Logon to Oracle E-Business Suite as SYSADMIN
Choose the "Business Views Setup" responsibility
Navigate to Reports > Run > Pick Single Request > "Generate ALL Business Views"

In case you don't have "Business Views Setup" responsibility assigned to SYSADMIN user, please do the following:

Logon to Oracle E-Business Suite as SYSADMIN
Choose the "System Administrator" responsibility.
Navigate to Security > User > Define and add responsibility "Business Views Setup" to user SYSADMIN.

8. Login Discoverer
http://sys22.doyen.in:7777/

Discoverer Plus
http://sys22.doyen.in:7777/discoverer/plus






Discoverer Viewer

373634.1: Using Discoverer 10.1.2 with Oracle E-Business Suite Release 12