Return to Oracle eBS from APEX

Javier Gualda

Hi there,

I'm trying to get a way to come back to eBS menu from APEX without having to login again. Any idea how to handle?

Thanks in advance.

Scott Wesley

Have you considered the white paper?

https://www.oracle.com/technetwork/developer-tools/apex/learnmore/apex-ebs-extension-white-paper-345780.pdf

Or questions upto a decade old on the topic?

Oracle Apex Authentication with EBS

Or maybe checked this comprehensive post?

Integration of Oracle Apex and E-Business Suite R12: Integration of Oracle Apex and E-Business Suite R12

John_K

Assuming you have set up integration between the two properly, you can get part of the return URL from a profile value, then just append the rest. i.e.

select fnd_profile.value('APPS_SERVLET_AGENT') || '/OA.jsp?OAFunc=OAHOMEPAGE' home_url  from dual;

Have a application level item with a computation on it using the above. Then use that in either a navigation entry, button, or whatever method you want to use to trigger the "back" action.