Hi, Am running APEX 22.1.0 version. My issue is around create email links back into the application. My application was using normal URL's but I changed to friendly URL. this is when the problem started.
Because the size of the procedure code I had to make a procedure and call from APEX. I also need to run the same procedure from a JOB process.
Previously I was using LINK_ID := apex.mail.get_instance_url || apex_page.get_url(xxxxxxxx);
and this work perfectly. But once I moved to friendly URL. Via APEX page call to the proc from APEX works as expected. But running the same proc via a job process the i get
https://xxx.xxx.xxx/https://xxx.xxx.xxx/apex/r/dev/application/page?sessionid
Is this an Oracle bug or can there be an issue with the APEX hosting that caused this issue?