OIM11g-Configuring BI Publisher for OIM after OIM install

OIM allows you to point to BI Publisher during the install. But you can point OIM to BI Publisher after the OIM install as well. I am assuming here you don't have a BIP in place and interested in BI Publisher Standalone.

Currently OIM11g is only certified with BI Publisher 10g (10.1.3.4.1). Its not certified with BI Publisher 11g.

Here are the steps

1. Install BI Publisher 10G (10.1.3.4.1) standalone
2. Note down the BIP URL. (Ex http://host1.us.oracle.com:9704/xmlpserver)
3. Copy the file oim_product_reports_11_1_1_3_0.zip from MiddleWare_Home/IDM_Home/server/reports to BI Publisher Home/xmlp/XMLP/Reports directory
4. Unzip the zip file into a directory e.g oim. This will contain all the report templates for OIM
5. Login to BI Publisher as Administrator ( Default BIP Credentials are Administrator/Administrator)
6. Navigate to Admin Tab -> JDBC DataSources (Under Data Sources)
7. Define a DataSource Pointing to OIM schema. Make sure that the Data Source name is OIM JDBC . (Default OIM schema is DEV_OIM). Test the JDBC connection.
8. Now Go Back to Reports tab in BI Publisher . You should see the OIM reports ( You would have to click More button under Shared Folders to display these reports) , Open a report like User Summary and make sure you are able to get Data which confirms your proper datasoure creation.
9. You can point your OIM instance to this BI publisher using the MBeans installed as partof OIM install using EnterPrise Manager (Note: If you don't have the EM in your domain extend the domain to support EM)
10. Make sure that Admin server and OIM managed server is up.
11. Login to EM
12. On the LeftHand Side Navigate to Identity & Access -> OIM -> Your OIM Instance (Note: In a cluster you can pick either of available instances)
13. Right Click to open the Menu , you should see System MBean Browser, click it to open the Mbean browser on right hand side
14. Now on the Right Hand Side in the MBean Browser Navigate to Application Defined MBeans ->oracle.iam->Server (ServerName)->Application:oim->XML Config->Config->XMLConfig.DiscoveryConfig->Discovery
15. Click on the Discovery , You should see the properties listed on Right Hand Side. Select BIPublisher URL property double click to open it.
16. Enter URL of your BIP instance here (ex http://host1.us.oracle.com:9704/xmlpserver)
17. Click Apply to save the change . Click Return to go back to main mbean browser page
18. Restart the OIM Managed Server
19. Login to OIM as administrator, Navigate to Advanced Administration and Click on BI Publisher Reports. This should open a BIP page and should ask for Credentials. Upon successful login you can view the OIM related reports.

Note: If you have Oracle Access Manager (OAM) configured as SSO solution for BIP and OIM you can perform SSO between OIM and BIP without getting challenged again.

Note: If you wire BIP during the OIM install , it will create the Data Source. You would only have to copy the report templates (Steps 3 & 4)