Hello,
Our company has an APEX application (originally created in version 3.x) which relies on Partial Page Refresh reports and AJAX htmldb_get() calls. We recently updated to APEX 4.1 along with integrating OAM 11g (we did not use OAM prior but had some other method of SSO that I do not recall). After updating to 4.1 and adding OAM we now have an unusual timeout issue. The user will be using the app continuously for about 1hr when they will encounter an error because the htmldb_get() call or PPR report failed. This error will occur once then go away until another hour has passed. I am thinking that because the app relies mostly on PPR reports and AJAX calls and does not submit any pages that the OAM cookie is not being refreshed properly and timing out. In testing, when the page is refreshed every so often this error does not occur. Our idle timeout is currently set at 240min but in the OAM documentation it states "These cookies are updated periodically using an algorithm of 1/4 of idle session timeout." This would seem to correlate with the 1hr timer on the error our users are receiving. Also when tracing the header on the failed request it is being redirected to http://server//oam/server/obrareq.cgi.
Does anyone have any suggestions on how to modify the PPR/AJAX to refresh the cookies and/or prevent this error from occurring? Any help would be appreciated.
Thank you!