Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

obiee 11g & ebs integration

791541Aug 12 2011
Hi,
I have updated a 10g repository & catalog to 11g. I'm trying to get the OBIEE/EBS integration/logon working. I'm currently getting the following error in the nqserver.log.

[nQSError: 13024] Successful completion of init block 'Authentication' is required.

Below are captions of my configuration. I have followed the Integrating with Oracle E-Business Suite Security section of Oracle® Fusion Middleware Integrator's Guide for Oracle Business Intelligence Enterprise Edition 11g.

The integration is working for OBIEE 10g.

I have read plenty of blogs & posts but cannot find out what's work.

Thanks in advance for your help.

Phil

Connection pool - Execute on connect
============
call /* valueof (NQ_SESSION.ACF) */ APP_SESSION.validate_icx_session('valueof(NQ_SESSION.ICX_SESSION_COOKIE)')

authenticationschemas.xml
=================
<AuthenticationSchema name="EBS-ICX" displayName="Oracle eBusiness Applications ICX Session" options="noLogoffUI noLogonUI" >
<!-- Note: The name of the cookie here is site-dependent and needs to be customized. -->
<!-- The URL parameter name is fixed and should not be changed. -->
<RequestVariable source="cookie" type="auth" nameInSource="FINA" biVariableName="NQ_SESSION.ICX_SESSION_COOKIE"/>
<RequestVariable source="url" type="informational" nameInSource="acf" biVariableName="NQ_SESSION.ACF"/>
</AuthenticationSchema>


<SchemaKeyVariable source="cookie" nameInSource="FINA" forceValue="EBS-ICX"/>


instanceconfig.xml
=============
<EnabledSchemas>UidPwd,Impersonate,UidPwd-soap,Impersonate-soap,EBS-ICX</EnabledSchemas>
Comments
Locked Post
New comments cannot be posted to this locked post.