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 126.96.36.199, 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.
There are two sides (Oracle eBS & Oracle BI) where you need to make some preparations.
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.
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.
18 thoughts on “Integrating Oracle eBS R12 and Oracle BI 11g”
Waiting for the post “Data Security in Oracle BI, based on the Oracle eBS Responsibility.”
I can recommend the following; https://obibb.wordpress.com/2012/10/18/setup-oracle-bia-7963-data-security/
I tried both of the above settings, it worked if you login directly through OBIEE webpage, but when you are moving through eBS, the language setting were overwritten of obiee by eBS. In eBS we only have english language :((… Is there any other place where we can set the lang in the eBS session.
I also searched to change the data format from (10,000,00.00) to ( 10.000.00,00) but couldn´t find anything on data format specific.
Try to set the USERLOCALE Session Variable; http://docs.oracle.com/cd/E23549_01/bi.1111/e10540/variables.htm
Robin Moffat has made a detailed blogpost about the USERLOCALE Session Variable;
Appreciate your details analysis, we have a different situation at our customer. They have not implemented any language on eBS except english, whereas the data which they want to see in BI APPS should be in european format ( instead of 10,000.00 they want 10.000,00). Now since the user is navigating through eBS, the default language is US english, which is very annoying for the users.
Any help would be highly appreciated.
Check here; http://docs.oracle.com/cd/E14571_01/bi.1111/e10541/deploylocal.htm and here; http://gerardnico.com/wiki/dat/obiee/locale for details on Localizing Oracle Business Intelligence.
One option I note in the authenticationschema file is the options=”NoLogoffUI NoLogOnUI”
My guess is that it’s OK to leave these in place, but I cant find any documentation on the file. Have you seen any documentation from Oracle?
I am not aware of any specific documentation regarding the authenticationschemas.xml. There are only references to this file in the documentation.
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.
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=*****
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 188.8.131.52.0  and later
Information in this document applies to any platform.
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?
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.