2 Replies Latest reply: May 15, 2014 8:54 AM by DaanBakboord RSS

    OBIEE 11.1.1.7 Integration with EBS R12

    911309

      Hi All,

       

      We are trying to integrate R12 with OBIEE 11.1.1.7. We want the user logging to EBS to click on the link in EBS to navigate to OBIEE seemlessly without having to enter the userid/password again.

       

      We have done the following steps

       

      1. we have added the following script in the connection pool

      call /* valueof(NQ_SESSION.ACF) */

      APP_SESSION.validate_icx_session('valueof(NQ_SESSION.ICX_SESSION_COOKIE)')

       

       

      2. Created the init block

       

      select FND_GLOBAL.RESP_ID,

      FND_GLOBAL.RESP_APPL_ID,

      FND_GLOBAL.SECURITY_GROUP_ID,

      FND_GLOBAL.RESP_NAME,

      FND_GLOBAL.USER_NAME,

      FND_GLOBAL.USER_ID,

      FND_GLOBAL.EMPLOYEE_ID

      from dual

       

      followed the oracle document http://docs.oracle.com/cd/E14571_01/bi.1111/e16364/ebs_actions.htm#CJAFDEIB

       

      But when i try to login it still takes me to the login page. Am I missing something here? Kindly help out.

       

      Regards,

      Deep