Discoverer 10.1.2 with Oracle E-Business 11i & R12

Discoverer 10.1.2 with Oracle E-Business 11i & R12:

Step 1:

Edit below parameters on $CONTEXT_FILE

For 11i:

<discoinstancename oa_var="s_discoinstance">devsoadl1.singiri.com_<portno></discoinstancename>
         <disco_machine oa_var="s_disco_machine"> devsoadl1.singiri.com </disco_machine>
         <disco_port oa_var="s_disco_port" oa_type="PORT"><portno></disco_port>

        <oa_process_status oa_var="s_discostatus" osd="unix">disabled</oa_process_status>

For R12:

The Disco Url Variable Name : “ s_disco_url”

<disco_url oa_var="s_disco_url" customized="yes">http:// devsoadl1.singiri.com:6669</disco_url>

         <disco_eul_prefix oa_var="s_disco_eul_prefix">EUL</disco_eul_prefix>

Note: As Webcache is the the entry point for discoverer, we have to use the Webcache SSL or Non-SSL port in "s_disco_url". You can get the appropriate Webcache port by keying in the command "opmnctl status -l"

Step 2:

Run AutoConfig to generate all configuration files for the APPL_TOP and the ORACLE_HOMEs in its supporting technology stack:

Step 3:

Update tnsnames.ora file

Step 4:

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.

Ensure the following ICX profile options in Oracle E-Business Suite are set to:

Profile	Description	Value
ICX: Discoverer Launcher	URL that points to Discoverer Plus Servlet.	http://<HTTP Server>:<Port> /discoverer/plus ?Connect=[APPS_SECURE]
ICX: Discoverer Viewer Launcher	URL that points to Discoverer Viewer Servlet	http://<HTTP Server>:<Port> /discoverer/viewer ?Connect=[APPS_SECURE]
ICX: Discoverer Release	Single number specifying the Discoverer release	10
ICX: Discoverer use Viewer	Specify whether Discoverer Viewer should be launched instead of Discoverer Plus (default).	Yes | No
ICX: Discoverer Default End User Layer Schema Prefix	The EUL prefix in combination with the Language code make up the EUL owner at runtime. For example EUL owner EUL_US has EUL prefix EUL.	EUL
ICX: Discoverer End User Layer Language Override	Since the End User Layer content is currently available in US English only, it is possible to override the user's general language preference for the Discoverer End User Layer using this profile option. The specified End User Layer language will be used regardless of the individual user's language preferences. This profile does not affect the National Language Support parameters passed to Discoverer. The Discoverer User Interface will still appear according to the users ICX_LANGUAGE and ICX_TERRITORY profiles. The User Interface language will only change for valid combinations of ICX_LANGUAGE and ICX_TERRITORY.	American English
ICX: Discoverer Parameters	This profile can be used to optionally pass additional URL parameters to Discoverer.	<NULL>
Discoverer DBC filename override	This profile can be used to specify the DBC Filename Discoverer should be using to connect to the E-Business Suite database. By default, this profile should remain NULL, in which case Discoverer will use the default dbc file for your E-Business Suite database.	<NULL>

Step 5:

To verify the values

#sqlplus apps/<apps password>

set linesize 140

set pagesize 132

column NAME format A40

column VALUE format A80 wrap

select  

n.user_profile_option_name NAME,

v.profile_option_value VALUE

from apps.fnd_profile_options p,

                 apps.fnd_profile_option_values v,

                apps.fnd_profile_options_tl n

where p.profile_option_id = v.profile_option_id (+)

and p.profile_option_name = n.profile_option_name

and v.level_id=10001

AND n.LANGUAGE='US'

and upper(n.user_profile_option_name) like upper('%&profile_name%');

Enter value for profile_name: ICX: Discoverer

NAME                                     VALUE

------------------- --------------------------------------

ICX: Discoverer Launcher  http://devsoadl1.singiri.com:<port>/discoverer/plus?Connect=APPS_SECURE]

ICX: Discoverer Default End User Layer Schema Prefix            EUL

ICX: Discoverer Viewer Launcher  http://devsoadl1.singiri.com:<port>/discoverer/viewer?Connect=[APPS_SECURE]

ICX: Discoverer use Viewer                                                     Y

ICX: Discoverer Release                                                          10

ICX: Discoverer End User Layer LanguageOverride               US

Step 6:

Copy Database Connection file

$FND_SECURE/<two_task>.dbc

$FND_SECURE/<database host name>_<two_task>.dbc

make a copy of your dbc file on your OracleBI Discoverer node $FND_SECURE directory and rename the file to match above default naming convention. Also make sure that the dbc file is saved in lower case only.

 for  EUL_US version :

SQL> select ver_min_code_ver from EUL_US.eul5_versions;

VER_MIN_CODE_VER

------------------------------

10.1.2.45.20

DISCOVER Node: Linux users Only:

Replace the line LD_ASSUME_KERNEL= 2.4.19 with following lines in $ORACLE_HOME/discoverer/discwb.sh before Import/Refreshing the EUL.

+++++++++++++++++++++++++++++++++++++++++++++

Note:   

ID 373634.1 , 762870.1