I'm using web.show_document to launch my apex application from oracle forms in Oracle eBusiness Suite. This works fine, except that the application uses security to check whether you are logged in. It uses single signon with oracle eBS. So if I want to navigate to a page, something like this
l_url := (FND_PROFILE.Value ('FND_APEX_URL') || '/f?p=107:55:' || l_session || '::NO:RP:P55_CONTRACT_ID,P55_REPO_CONTRACT_ID:'
|| to_char (l_po_contract_id) ||',' || to_char (l_contract_id);
WEB.Show_Document (l_url);
--WEB.Show_Document ('.../ords/f?p=107:55:13356486872367::NO:RP:P55_CONTRACT_ID,P55_REPO_CONTRACT_ID:708485,10131');
Without the session it simply goes to the first page. If I navigate to the page and copy the link with the session it works fine from forms, but after a while the session will time out of course and it goes to the first page as well.
I also tried this
https://www.talkapex.com/2012/08/how-to-create-apex-session-in-plsql/
to create a session through PL/SQL and use the session parameter, but that doesn't work either. Any thoughts? The cookbook only shows an example without a session ...