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 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.

Goal

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?

Solution

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