This discussion is archived
2 Replies Latest reply: Aug 30, 2013 2:28 PM by kkarri RSS

EBS R1213 integration with OBIEE 11.1.1.7.0 failed

903069 Newbie
Currently Being Moderated

1. EBS link: http://xyz-d1576o.gen.local
2. Created function, menu, responsibility, user and profile.

OBIEE link passed: http://abc.mno.local:7001 (please help me in finding domain of EBS and OBIEE is same)
3. Enabled Oracle EBS OLTP Initblocks Connection Pool
4. Created USER session variable for this initialization block.
5. Not Selected Required for authentication checkbox. (so that Weblogic Users can access reports and dashboards & rpd online).
6. Updated authenticationschemas.xml at two places for InSource.
7. Verified cookie by running:
SQL> call app_session.validate_icx_session('hJ0ViXQFoyaO3oHZzU7OJCPDRh ');
Call completed.
SQL> select fnd_global.user_name from dual;
Returned user.
8. Updated instanceconfig.xml
<EnabledSchemas>UidPwd,Impersonate,UidPwd-soap,Impersonate-soap,EBS-ICX</EnabledSchemas>
9. Restarted the bi services.

When trying to navigate from EBS to OBIEE, it's showing the login page. It's not logging directly to OBIEE.

nqserver.log extract

[nQSError: 23006] The session variable, NQ_SESSION.ICX_SESSION_COOKIE, has no value definition.
[[[nQSError: 13011] Query for Initialization Block 'EBS Security Context' has failed.]]
[2013-06-13T12:43:39.000+02:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: aace17b3548f6190:446edeb0:13f08b3f5e2:-8000-000000000002b800] [tid: 45d8f940]
[nQSError: 13011] Query for Initialization Block 'EBS Security Context' has failed.
[2013-06-13T12:43:39.000+02:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: aace17b3548f6190:446edeb0:13f08b3f5e2:-8000-000000000002b800] [tid: 45d8f940]
[nQSError: 43126] Authentication failed: invalid user/password.

sawlog1.log extract

Authentication Failure.
Odbc driver returned an error (SQLDriverConnectW).
State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 43126] Authentication failed: invalid user/password.
[NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection i
s refused.

[nQSError: 43113] Message returned from OBIS.

[nQSError: 43126] Authentication failed: invalid user/password.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points