Setting Up the Oracle E-Business Suite Security in Oracle BI Publisher 10.1.3.4.2

Brief:
Oracle BI Publisher can use Oracle eBusiness Suite security by which users can login to Oracle BI Publisher using EBS Username and Password. Once we setup the security, the EBS responsibilities will be available in the BI Publisher as roles. And then you can add Oracle BI folders and Data Sources to above mentioned auto imported Roles.

Setup:

   Part A: Setup Oracle eBusiness Suite

1. Login to Oracle eBusiness Suite as SYSADMIN
2. Create a dummy menu TEST BI PUBLISHER  (with no functions)
3. Create following six responsibilities as shown in the screenshot :
1. XMLP_ADMIN – this is the administrator role for the BI Publisher server
2. XMLP_DEVELOPER – allows users to build reports in the system.
3. XMLP_SCHEDULER – allows users to schedule reports.
4. XMLP_ANALYZER_EXCEL – allows users to use the Excel analysis feature.
5. XMLP_ANALYZER_ONLINE – allows users to use the online analysis feature.
6. XMLP_TEMPLATE_DESIGNER - allows users to connect to the BI Publisher server from the Template Builder and to upload and download templates.
   
   
   



4. Add the above responsibilities (based on the need) to the Oracle eBusiness Suite user
5. Get dbc file from EBS Application server, which will be used during setting up the Oracle BI Publisher. And you can find the dbc at $FND_SECURE location.

    Part B: Setup Oracle BI Publisher Enterprise

1. Install Oracle BI Publisher Enterprise (OBIPE) [ For Installation follow the Oracle Document ]
2. Get Oracle eBusiness Suite dbc file. The file is located in Oracle 
3. Login to OBIPE as Administrator
4. Enable Local Superuser as follows:
1. Click Admin Tab
2. Click on Security Configuration
3. Select Enable Local Superuser
4. Enter Superuser Name [Any meaningful name]
5. set Password
6. Scroll down to Security Model
7. Set Security Model to Oracle E-Business Suite
8. Click on Upload DBC File button to upload the dbc file
9. Apply to Save the changes
   



5. Stop and Start Oracle BI Publisher Enterprise to take the effect.
6. Login to the BI Publisher as a Local Superuser
7. Click on Admin Tab then Roles and Permissions
8. Add folder and Data Source to the Role
   
9. Logout from OBIE as Admin
10. Login again with E-Business suite credentials