APEX

Hi,

We have successfully integrated APEX page into EBS, i.e. we are able to invoke the APEX page from EBS Responsibility/Menu.

for APEX integration, we have installed APEX on separate OHS on the same server as EBS (and same domain) and in the Form Function HTML call we are using "GWY.jsp?targetAppType=APEX&p=160:10::" to invoke the APEX page.

Issue is, the APEX page displays error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small", which we are not able to capture or supress.
but the page functions as expected and insert/update of tables working fine, in short everything is as expected except that error message.

In Before Header we are calling a custom procedure, which invokes "wfa_sec.getsession( l_username);" to validate the ICX session, this is raising the error.

when i try call "ICX_SEC.getsessioncookie" before the above procedure, it returns valid Session ID and call to "ICX_SEC.check_session" returns VALID; i am not sure why it is throwing error to validate an available Valid session?

All we want is to use the same ICX session in APEX page without need to pass the User name/password or re-login in APEX or set the User/Responsibility context again.

any help would be appriciated.

Rgds,
-Kamal

Edited by: Kamal on 30-Oct-2012 01:11