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]


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.

   <ExternalLogon enabled="true">
      <Param name="NQ_SESSION.ACF"

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.

One thought on “Integrating Oracle eBS and Oracle BI EE – Getting started

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.