Integrating Oracle eBS and Oracle BI EE – Getting started

I have been playing around with Oracle eBS Release 12 and Oracle BI EE 10g. 

In Release 12 the integration is very straight forward. If you would like to achieve the same functionality in Release 11, you need to do some patching first.

Lucky enough for me I am able to use an Release 12 environment.

select release_name
from   applsys.fnd_product_groups

All I had to do was set the ‘FND: Oracle Business Intelligence Suite EE base URL’-profile in Oracle eBS.

This would be something like; http://[hostname.domain_name]:[port_number]

statement:

select fnd_profile.value('FND_OBIEE_URL') oracle_bi_url
from   dual

Now Oracle eBS nows where to find Oracle BI.

Secondly I had to change the way Oracle BI authenticates in the instanceconfig.xml file. This way you can login to Oracle BI via Oracle eBS. You use your Oracle eBS credentials to login to Oracle BI directly.

   <Auth>
   <ExternalLogon enabled="true">
      <ParamList>
      <Param name="NQ_SESSION.ICX_SESSION_COOKIE"
         source="cookie"
         nameInSource="VIS"/>
      <Param name="NQ_SESSION.ACF"
         source="url"
         nameInSource="acf"/>
      </ParamList>
   </ExternalLogon>
   </Auth>  

Last but not least, you change your connection settings in the Repository of Oracle BI and you are good to go.

If you would like to see how the integration between Oracle eBS and Oracle BI works, I can recommend a blogpost of Gerard Braat.

Robin Moffat has written a good explanation about how to validate EBS-BI authentication, without BI.