Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Oracle EBS R12 Integration with OBIEE 12c

Received Response
153
Views
10
Comments
ather.shaikh
ather.shaikh Rank 3 - Community Apprentice

Hi All,

We have done an out place upgrade with OBIEE Apps 11.1.1.7.1.

Now we are supposed to integrate SSO with Oracle EBS R12.

Do any body have any article or blog post, idea that how we can achieve that?

Keep in mind that we want it for OBIEE 12c. I have done many times for OBIEE 11g, but that is not working if we follow the same steps.

When user click on Oracle EBS responsibility for OBIEE , it navigates to OBIEE but still showing login page and not login to the OBIEE with same user.

Regards,

Ather

Answers

  • Stijn Gabriels
    Stijn Gabriels Rank 1 - Community Starter

    Hi Ather,

    I've the same issue. I checked the loggin in the databases and it appears to me that all Init Blocks are executed properly, but the user is still not logged in.

    I found these error messages:

    [OBI-SEC-00110] FailedAuthentication: BI Security access denied - missing web service credentials

    BI Security Service access denied – Web Service Security SOAP header credentials are missing or empty

    Can you confirm you get the same error messages?

    I think it is something internally in BI. In 11g we had the BI System User who 'assisted' during the authentication process, but in 12c it has been removed. To me it looks that there are some settings (or credentials) which need to be set in order to make the new way of authentication working.

    Oracle BI 12c documentation says:

    BISystemUser and BISystem RemovedTo simplify administration and configuration in this release Oracle Business Intelligence no longer requires a real user called BISystemUser (or equivalent) for internal communication. The system user concept is now deemed "virtual" and is represented by the credential oracle.bi.system/system.user, for which the values are securely randomly generated by the Configuration Assistant. Oracle BI components continue to use this credential for internal communication, backed by Oracle BI Security. The application role BISystem is also no longer present in the Policy Store, and will be removed from any upgraded 11g environment.

    https://docs.oracle.com/middleware/1221/biee/BIESC/whatsnew.htm#BIESC390

    So, I guess something is wrong with the credential oracle.bi.system/system.user. But I don't know how to fix this.


    Please let me know if you already got further with this issue. Thanks!

    Regards,
    Stijn

  • Srini Chavali-Oracle
    Srini Chavali-Oracle Rank 3 - Community Apprentice

    Have you reviewed MOS Doc 2174747.1

  • ather.shaikh
    ather.shaikh Rank 3 - Community Apprentice

    Hi Gabriels,

    Yes, I am getting the same issue, but in the fron i am having Access Prohibited , when i try to login through Oracle EBS.

    Regards,

    Ather

  • ather.shaikh
    ather.shaikh Rank 3 - Community Apprentice

    Hi Srini,

    I followed the same steps including the missing steps and access prohibited steps. I restarted all the services but no change, I am still getiing Access Prohibited, while trying to login from Oracle EBS.

    Regards,

    Ather

  • ather.shaikh
    ather.shaikh Rank 3 - Community Apprentice

    Hi All,

    All is done and finally I am able to login to OBIEE 12c, trough Oracle EBS R12.1.3

    Thanks to All for their support.

    Regards,

    Ather

  • Stijn Gabriels
    Stijn Gabriels Rank 1 - Community Starter

    Hi Ather,

    We're still facing this issue. Can you point me to any details that helped you fixing this issue?

    Thanks,
    Stijn

  • Stijn Gabriels
    Stijn Gabriels Rank 1 - Community Starter

    And which OBIEE release are you using? 12.2.1.2.0?

  • ather.shaikh
    ather.shaikh Rank 3 - Community Apprentice

    Hi,

    I used the following Oracle Document and

    https://blogs.oracle.com/proactivesupportEPM/entry/km_obiee_12cintegrateebs

    including the missing information provided in it.

    Regards,

    Ather

  • 964896
    964896 Rank 1 - Community Starter

    @Stijn Gabriels we are running into the same issue with OBIEE 12.2.1.2 against EBS R12 (12.2.5). Were you able to resolve the issue on your end?

    - David

  • ather.shaikh
    ather.shaikh Rank 3 - Community Apprentice

    I followed the steps as mentioned in the document carefully.

    https://blogs.oracle.com/proactivesupportEPM/entry/km_obiee_12cintegrateebs

    all the problems were resolved.

    Regards,

    Ather