I need to make session timeout period for my apex application for 24 hours.
I had experience with same task when working with Apex 4.2.4 and tried to resolve it same way.
I chose "Edit application Properties" -> "Security" -> "Session Management Settings". I set both parameters "Maximum Session Length in Seconds" and "Maximum Session Idle Time in Seconds" to value 86400. And also I disabled DBMS_Scheduler job "APEX_050000.ORACLE_APEX_PURGE_SESSIONS" to prevent clearing sessions elder than 12 hours.
But it was a fail...
Sessions becomes invalid after 12 hours after log in. I looked around a bit and found view, that showed me strange thing: I can not set session timeout more than 12 hours (sic!) in Apex 5.
select WORKSPACE_ID,WORKSPACE_NAME,WORKSPACE_DISPLAY_NAME,APEX_SESSION_ID,USER_NAME,SESSION_CREATED,SESSION_IDLE_TIMEOUT_ON,SESSION_LIFE_TIMEOUT_ON,SESSION_MAX_IDLE_SEC
from APEX_WORKSPACE_SESSIONS
order by session_created desc
This SQL query showed me that session life couldn't last longer than 12 hours. I tried to set "Maximum Session Length in Seconds" and "Maximum Session Idle Time in Seconds" less than 43200 and it works fine. Session becomes invalid immediate after SESSION_LIFE_TIMEOUT_ON comes.
But when I set Session length more than 43200 it looks like SESSION_LIFE_TIMEOUT_ON calculated by APEX as SESSION_CREATED+12/24.
Could anyone help me to resolve this problem?
Best regards,
Sergey