How to Accomplish a Timeout After 15 Minutes of User Inactivity within APEX for Long Running Query or Report
Last updated on MAY 21, 2018
Applies to:Oracle Application Express (APEX) - Version 5.1.3.00 to 5.1.4.00.08 [Release 5]
Information in this document applies to any platform.
The APEX_UTIL.SET_SESSION_MAX_IDLE_SECONDS is set to 900 ( 15 minutes). A long running report runs for approximately 30 minutes. This long running report (or page query) fails with a timeout. Is it possible to set the time out in such a way that the maximum idle time in APEX does not affect long running reports? This concept is similar to FORMS_TIMEOUT, which allows a query to complete before the timer for the "time out" setting starts.
Is there any way to accomplish this in APEX?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms