My Oracle Support Banner

How to Accomplish a Timeout After 15 Minutes of User Inactivity within APEX for Long Running Query or Report (Doc ID 2401459.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Application Express (APEX) - Version to [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?


To view full details, 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 a vibrant support community of peers and Oracle experts.