Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Oracle EBS R12 Integration with OBIEE 12c

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
-
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,
Stijn0 -
Have you reviewed MOS Doc 2174747.1
0 -
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
0 -
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
0 -
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
0 -
Hi Ather,
We're still facing this issue. Can you point me to any details that helped you fixing this issue?
Thanks,
Stijn0 -
And which OBIEE release are you using? 12.2.1.2.0?
0 -
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
0 -
@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
0 -
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
0