Hello everybody,
I have problem with APEX 5.0 and EBS integration, in a custom way, with session as parameter in cookie.
Session id should be taken by function apps.icx_sec.getsessioncookie (see query below).
SELECT fnd_user.user_name
INTO p_userid
FROM icx_sessions,
fnd_user
WHERE session_id = apps.icx_sec.getsessioncookie
AND icx_sessions.user_id = fnd_user.user_id
AND last_connect + (time_out / 24 / 60) > SYSDATE;
That is not first time to create integration in this way. But this time I have problem. I do not have access to APEX and EBS servers, and system administrator probably close some inbound port on servers. Because of that, function apps.icx_sec.getsessioncookie cannot return session id from cookie. Does anybody have idea what could be problem?
I want to say that EBS and APEX are in the same database, but application servers are on different locations.
Also it is very important to say that last week that integration was working perfectly.
Regards,
D.