Integrating Oracle eBS R12 and Oracle BI 11g

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)

authenticationschemas.xml (SchemaKeyVariable)

authenticationschemas.xml

  • instanceconfig.xml (ORACLE_INSTANCE/config/OracleBIPresentationServicesComponent/coreapplication_obips1)

instanceconfig.xml

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.

Author: Daan Bakboord

I am an Oracle Business Analytics Consultant with great interest in anything closely related to the Oracle Business Analytics (OBIEE, BICS, Big Data, Data Integration, Data Visualization) .

18 thoughts on “Integrating Oracle eBS R12 and Oracle BI 11g”

  1. Hi Daan,

    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.

    Regards,
    Ajay

    Like

  2. Hi,

    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.
    Thanks,
    Aj

    Like

  3. Hi Daan

    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?

    Adrian

    Like

    1. Hi Adrian,

      I am not aware of any specific documentation regarding the authenticationschemas.xml. There are only references to this file in the documentation.

      – Daan

      Like

  4. 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,

    Like

  5. 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.

    Like

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s