Hi There,
I am trying to pass an FND username or ICX session id to APEX from Oracle eBusiness to load employee's information. From the Oracle while paper and/or Rod West's document, it states that we can use the functions defined below.
wfa_sec.getsession(<username outparameter>) ;
icx_sec.getsessioncookie;
Both of these functions return -1 or goes into exception. I have confirmed with our DBAs that both APEX and eBusiness are installed on the same domain. APEX has access to APPS schema but its connected to one of our custom schema.
Any idea why this doesn't work?
In addition, how can I pass the fnd username through the URL using the LaunchApex.jsp (SSWA jsp function) or the GWY.jsp?targetAppType=APEX&p101:1 (JSP Interoperable with OA) methods? Any examples? And how can we apply a checksum to the URL, since it originated in Oracle eBusiness.