tag:blogger.com,1999:blog-5335298937717802658.post3851249780447076873..comments2024-03-02T07:03:10.695+01:00Comments on Integration of Oracle Apex and E-Business Suite R12: Authentication, Authorization and more Shared ComponentsMarchttp://www.blogger.com/profile/10866634261254073409noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-5335298937717802658.post-28919187953923923722019-10-11T15:16:41.465+02:002019-10-11T15:16:41.465+02:00Marc
My integration between APEX 5.1 and EBS 12.1...Marc<br /><br />My integration between APEX 5.1 and EBS 12.1.3 is working fine, but I encounter a situation where I am a little but stuck.<br /><br />In my APEX APP I use an IR, where the end user must be able to save his/her private reports. Now when EBS sessions are passed to APEX (according your article) all is working fine, but the user is not able to save private reports. I think this is resulting from the fact that 'No Authentication'-scheme is used.<br /><br />Do you know a way to enable the 'Save'-action in the "Actions"-menu?<br /><br />Kind Regards<br />OlivierOlivierhttps://www.blogger.com/profile/01752771015371980892noreply@blogger.comtag:blogger.com,1999:blog-5335298937717802658.post-5438949359071090062018-05-03T10:51:47.715+02:002018-05-03T10:51:47.715+02:00Hi I am also getting the same error. apps.icx_sec....Hi I am also getting the same error. apps.icx_sec.getsessioncookie call returns -1. Has anybody been able to resolve this issue. Can you please share hoe to rectify it. Thanks.Anonymoushttps://www.blogger.com/profile/16577532285822630813noreply@blogger.comtag:blogger.com,1999:blog-5335298937717802658.post-54695464615836594232018-02-21T13:57:48.370+01:002018-02-21T13:57:48.370+01:00hi guys could you please provide the custom jsp t...hi guys could you please provide the custom jsp to resolved this issue " apps.icx_sec.getsessioncookie call returns -1. The EBS application is in server1 and APEX is in server2"<br /><br />please i have been looking for this solution , please also provide the new code authorization after amending the <br /> mphohttps://www.blogger.com/profile/04924516131266058855noreply@blogger.comtag:blogger.com,1999:blog-5335298937717802658.post-60932099677539280502015-11-21T03:35:24.205+01:002015-11-21T03:35:24.205+01:00Hi Guys Does anyone can share with me this custom ...Hi Guys Does anyone can share with me this custom jsp? I 'm having this : apps.icx_sec.getsessioncookie call returns -1. The EBS application is in server1 and APEX is in server2.<br /><br />Thanks,<br /><br />Edu MendesEdu Mendeshttps://www.blogger.com/profile/08865550492866229621noreply@blogger.comtag:blogger.com,1999:blog-5335298937717802658.post-48534938452802060232015-06-03T10:56:08.119+02:002015-06-03T10:56:08.119+02:00Hi Donald,
We are facing the same problem when ...Hi Donald, <br /><br />We are facing the same problem when integrating EBS and Apex on different domains.<br />Could you provide me more information / instruction how to add custom cookie rewrite in the GWY.jsp?<br /><br />Thanks,<br />RamAppsDBAhttps://www.blogger.com/profile/02288720832153663584noreply@blogger.comtag:blogger.com,1999:blog-5335298937717802658.post-48258942671444573062015-06-03T10:55:02.501+02:002015-06-03T10:55:02.501+02:00This comment has been removed by the author.AppsDBAhttps://www.blogger.com/profile/02288720832153663584noreply@blogger.comtag:blogger.com,1999:blog-5335298937717802658.post-66752458184245599072015-04-24T13:00:31.683+02:002015-04-24T13:00:31.683+02:00do you have a copy of the custom cookie rewrite in...do you have a copy of the custom cookie rewrite in the GWY.jsp; we are facing a weird issue where the cookie is not getting set in the IE8 (apps.icx_sec.getsessioncookie call returns -1) and i think the custom GWY.jsp will solve our issue.Shams Ahmed (Shamshed Ahmed)https://www.blogger.com/profile/12480612947950778101noreply@blogger.comtag:blogger.com,1999:blog-5335298937717802658.post-6659012394417882092014-12-15T10:57:11.562+01:002014-12-15T10:57:11.562+01:00Hi Donald,
Thank you for your valuable contributi...Hi Donald,<br /><br />Thank you for your valuable contribution. I am running into the same problem as you described having EBS using https and APEX on http. You resolved this by adding a custom cookie rewrite in the GWY.jsp to write out another unsecured cookie. Can you give me more information / instruction how to achieve this. Thanks in advance.<br /><br />Kind regards, Marc Marchttps://www.blogger.com/profile/10866634261254073409noreply@blogger.comtag:blogger.com,1999:blog-5335298937717802658.post-14214097421409375262014-09-26T14:38:41.605+02:002014-09-26T14:38:41.605+02:00Hi Marc,
I will answer it by myself. :)
We do not...Hi Marc,<br /><br />I will answer it by myself. :)<br />We do not need any sepcial grants as we will use a package within apps schema and "definer authid"!<br /><br />So we only need the execute grants on this package.<br /><br /><br />Thanks<br />KaiKai G.https://www.blogger.com/profile/13953501150299121023noreply@blogger.comtag:blogger.com,1999:blog-5335298937717802658.post-74235692848667157832014-09-26T12:23:37.482+02:002014-09-26T12:23:37.482+02:00Hi Marc!
Nice and useful blog post!
Do you also h...Hi Marc!<br /><br />Nice and useful blog post!<br />Do you also have a list of needed grants to execute the package "apps.icx_sec.getsessioncookie" as the apex user?<br />I think apart from the execute grant there are also couple of select grants needed for fnd and icx tables/views, right?<br /><br /><br />Thanks<br />KaiKai G.https://www.blogger.com/profile/13953501150299121023noreply@blogger.comtag:blogger.com,1999:blog-5335298937717802658.post-85498974702471748182014-08-13T15:35:33.297+02:002014-08-13T15:35:33.297+02:00@Sarvesh, you can't use the cookie because the...@Sarvesh, you can't use the cookie because they are on different domains. This is a strict cookie policy. My suggestion would be to write a custom jsp passing the cookie value encrypted with a seed to APEX in the url. Then you can decrypt the cookie in APEX domain and look up the needed information in the icx_sessions table.<br /><br />@Marc... just an fyi... Great article but besides different domains issue, I found another problem where EBS was using HTTPS and APEX (being a non external app) was using HTTP. The call in WHERE iss.session_id = apps.icx_sec.getsessioncookie will not work because the owa_cookie call in that function will not be able to see the secure EBS cookie from the APEX page (it wont exist). I had to add a custom cookie rewrite in the GWY.jsp to write out another unsecured cookie. Anonymoushttps://www.blogger.com/profile/00013010111337460987noreply@blogger.comtag:blogger.com,1999:blog-5335298937717802658.post-78829343756605050532014-08-08T19:46:52.985+02:002014-08-08T19:46:52.985+02:00Hi Marc,
Thanks for the such a good article, it h...Hi Marc,<br /><br />Thanks for the such a good article, it helped me to understand the concept. I'm trying to integrate EBS 12.1.3 with the APEX 4.1, but i'm unable to use the ICX session as EBS and APEX are on different domains. Please help me with the solution for this.<br /><br />Thanks,<br />SarveshAnonymoushttps://www.blogger.com/profile/07747133646005446663noreply@blogger.com