Following steps are required to integrate Oracle Business Intelligence Applications with Oracle E-Business Suite Application.
1) Single Sign On into Oracle E-Business Suite and have that authentication passed through to Oracle BIEE
2)Embed links to Oracle BI EE dashboard/catalog in Oracle E-Business Suite pages

3)Create Action Links within Oracle BI EE reports and dashboards that take you back into Oracle E-Business Suite in context.
Embedding a URL in Oracle EBS to open Oracle BI Interactive Dashboards
Follow the steps noted below to create a form function and to assign it to the right menus and responsibilities:

1. Log on as a user with System Administrator privileges (default sysadmin) into your Oracle E-Business Suite environment.
2. Select responsibility System Administrator from the responsibility navigator (left) pane.
3. After you select the responsibility from the left pane, the available menus are shown in the right pane.
Using these menus create the following objects in the sequence listed below:
a. Function
b. Menu
c. Responsibility
d. User
e. Profile
Creating the Function
1) From the Application menu, choose Function. This takes you to Oracle Applications Function form. Give your function a name, User Function Name and Description and save your changes.
2) From the Application menu, choose Function. This takes you to Oracle Applications Function form shown below. Give your function a name, User Function Name and Description and save your changes.
3) In the Function properties tab, enter value Type= SSWA jsp function
4) In the Web HTML tab, enter HTML Call=OracleOasis.jsp?mode=OBIEE&function=Answers
(For linking to the dashboard use function=Dashboard)
Creating the Menu
Create a new Standard menu and give it a Name and User Name. In the Function field, enter the name of the Function created in the previous step.

Assigning to a Responsibility
The menu that was created in the previous step needs to be associated with a responsibility. You can either create a new responsibility or reuse an existing responsibility. To create a new responsibility, follow the following steps:
Choose the application that you are creating the Menu for and for Responsibility Key define any unique value
1. Choose Oracle Self Service Web Applications under Application From and under Data Group choose Standard and reenter the Application name
.
2. For Menu, enter the value created in the Previous steps

Assigning Responsibility to the User
You can either create a new user or assign the responsibility created above to an existing user.

Assign a Profile
A profile can be set for a responsibility, a user or a site. In our example we will set profile options for a responsibility. Check the responsibility option and in profile type %oracle business% and click on Find.
This will bring you to another screen. Under responsibility, enter the URL of the Oracle BI EE environment

Oracle BIEE Setup
Configuring InstanceConfig.xml for External Authentication
1. Modify the instanceconfig.xml file for the Oracle BI Presentation Services as shown below:
http://URL:A_HTML/OA.jsp?OAFunc=OAHOMEPAGE
RDP Configuration
1) Go to Manage, Variables. Click properties for Session, Initialization Blocks, “EBS Security Context”. Click Edit Data Target. Remove OLTP_EBS_USER. Should then have 7 variables (but match with columns in the SQL you have if different) in order as follows :
- OLTP_EBS_RESP_ID
- OLTP_EBS_RESP_APPL_ID
- OLTP_EBS_SEC_GROUP_ID
- OLTP_EBS_RESP_NAME
- OLTP_EBS_USER_ID
- OLTP_EBS_EMPLOYEE_ID
- USER
3. Create a New Initialization Block EBS Responsibility to capture the OBIA Webgroups based on the Responsibilty. This is been used for Object and data Level Security
Select DISTINCT ‘GROUP’,BI_GROUP from xxbi_resp_group_map_v where RESPONSIBILITY_NAME in (SELECT RESPONSIBILITY_NAME
FROM FND_RESPONSIBILITY_TL WHERE RESPONSIBILITY_ID =’valueof(NQ_SESSION.OLTP_EBS_RESP_ID)’)