Integrating Oracle eBS R12 and Oracle BI 11g
16/08/2012 7 Comments
I have made a blogpost in the past about integrating Oracle eBS R12 and Oracle BI 10g. In the course of an upgrade of Oracle BI Applications (OBIA) to OBIA 7.9.6.3, I came to the subject of integrating Oracle eBS R12 and Oracle BI 11g. Of course you should start with the documentation. Next to that, Oracle provides a note on Oracle Support (ID 1343143.1). A lot of integration steps are equal to the 10g version.
In short:
There are two sides (Oracle eBS & Oracle BI) where you need to make some preparations.
Oracle eBS:
You need to define the link from to Oracle eBS to Oracle BI. This functionality hasn’t changed and I have described that process here. Combined with the ‘FND: Oracle Business Intelligence Suite EE base URL’-profile option in Oracle eBS, you now are ready to navigate from Oracle eBS to Oracle BI.
Oracle BI:
Now the Oracle eBS side is ready, you’ll have to prepare Oracle BI for accepting login requests from Oracle eBS. This parts differs a little from 10g. The changes in the Repository are still the same and consist of validation of the ICX-cookie in the Oracle eBS Connection Pool and the Authentication via Session variables. You can choose to either authenticate via the GROUP- system variable or directly via the new 11g ROLES-system variable.
After that you need to change the Oracle BI configuration;
- authenticationschemas.xml (ORACLE_HOME/bifoundation/web/display)
- instanceconfig.xml (ORACLE_INSTANCE/config/OracleBIPresentationServicesComponent/coreapplication_obips1)
Note: Don’t get mislead by the following sentence; ‘<!–This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control–>’. You must adjust these settings directly in the instanceconfig.xml itself.
This should (all) be sufficient to log into Oracle BI via a selected responsibility in Oracle.
In a following post I will cover the subject of applying Data Security in Oracle BI, based on the Oracle eBS Responsibility.
Pingback: Simulate Oracle eBS to Oracle BI login via SQL « Oracle BI By Bakboord
Pingback: Logout Link disappearing in Oracle BI 11g / Oracle eBS R12 integration « Oracle BI By Bakboord
Pingback: Setup Oracle BIA 7963 – Data Security « Oracle BI By Bakboord
Pingback: Navigating from Oracle BI 11g to Oracle eBS R12 « Oracle BI By Bakboord
Hello Daan,
Amazing post on eBs and OBIEE 11g integration, I will refer this blog going forward for this EBS OBIEE custom implementation.
Do you have a information about this note : 755768.1 OBIEE intregation with AD and R12 Ebusiness Suite. I am unable to access this from Oracle support. !!
Please let me know if you have a copy or information about this.
Also I was looking into OBIEE 11g: After Integration Between OBIEE 11g And EBS Is Done, Is It Possible For Non-EBS Users To Access OBIEE By Entering Their Credentials Directly With OBIEE [ID 1452451.1]
Business Intelligence Answers Option – Version 11.1.1.5.0 [1308] and later
Information in this document applies to any platform.
————————————————————————————————-
Goal
After integration between OBIEE 11g and EBS is done, is it possible for Non-EBS users to access OBIEE by entering their credentials directly with OBIEE?
Fix
When EBS-OBIEE instegration is in place, you can login to OBI standalone with any user from the Authentication providers you may have configured in Weblogic.
The setup for EBS-OBI integration involves the use of init blocks, as it was done in 10g.
However, you may not be able to login to OBI standalone with users you retrieve through init blocks.
This is because the Authentication Providers in Weblogic take precedence over any authentication process from init blocks.
For example, you can login to BI standalone with weblogic user
————————————————————————————————
My questions regarding the above note:
So according to the note above after EBS OBIEE integration weblogic user/AD user should be able to login to EBS OBIEE integrated instance provided the users do not exist in EBS/or could not be retrieved thru init blocks .?
Would be great if someone could provide some insight on this.
Thanks in advance.
Vidya.
Hi Vidya,
Note 755768.1 is probably not visible for the public.
For a direct login, without log into Oracle eBS first, try; http://host_name:port/analytics/saw.dll?Answers&nQUser=UserName&nQPassword=*****
- Daan
Hello Daan,
It works with AD Provider by setting virtualize = true property for multiple authenticators. Weblogic authentication providers takes precedence over init blocks authentication if ‘Required of authentication’ is not set.
Thanks,
Vidya,