ICX: Session Timeout and autoconfig variable s_oc4j_sesstimeout in 12.0.4

Recently we came across a forms time out issue. All the user forms sessions were getting disconnected after an Hour. The FORMS_TIMEOUT variable was set to 120 mins though. This should practically disconnect the forms session after 2 hours.

Here the reason for the issue is because of the mismatch of the ICX and OC4J timeout session parameters.

OC4J session timeout, if not set, defaults to 20 minutes. This will cause the oc4j session to timeout
before the Apps/ Forms session timeout which is defined by profile option "ICX: Session Timeout"

Profile option "ICX: Session Timeout" and autoconfig variable "s_oc4j_sesstimeout" in context file should match.

Example:

 In case you need the session to timeout after 2 hrs then the profile option "ICX: Session Timeout" and autoconfig variable "s_oc4j_sesstimeout" should be set to 120.

Unable to authenticate session in Oracle apps R12 (12.0.4): Login Issue

Unable to authenticate session in Oracle apps R12 (12.0.4): Login Issue

The Release 12.0.4 instance was cloned from another identical instance.

When we try to login, the login page does not display

Have tried clearing the cache (_pages). Have tried recompiling jsps and bouncing however the problem still persists. 

Cleared all the Apache and related logs and found an interesting error.

 It is in the following log file:

$INST_TOP/logs/ora/10.1.3/j2ee/oacore/oacore_default_group_1/application.log

08/08/21 15:17:00.601 10.1.3.0.0 Started

08/08/21 15:17:02.769 html: 10.1.3.0.0 Started

08/08/21 15:17:33.132 html: oracle.apps.fnd.security.LeakDetectionFilter.initialized:1219349853132

08/08/21 15:17:33.132 html: LeakSetting:

global:true,session:false,aggressive:false,stderr:false,appslog:false,corelog:false

ignoring:null

08/08/21 15:17:34.859 html: chain failed

javax.servlet.ServletException: java.lang.RuntimeException: Unable to create user session. Please contact your System Administrator.

at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.EvermindPageContext.handlePageThrowable(EvermindPageContext.java:780)

Solution:

Enable FND debug

The FND debug log had the below error:

Oracle error -1654: ORA-01654: unable to extend index APPLSYS.FND_LOGINS_N2 by 16 in tablespace APPS_TS_ARCHIVE has been detected in FND_SIGNON.AUDIT_USER. 

Check if the APPS_TS_ARCHIVE Tablespace is full.

Increase the size of tablespace APPS_TS_ARCHIVE / add a datafile to the tablespace. 

This will resolve the issue.

Rolling back an Autoconfig session

Rolling back an Autoconfig session.


Each execution of Autoconfig creates a rollback script in case you need to revert to previous configuration settings. 


This script and all backup configuration files from each autoconfig session are stored in:


Tier                                       Directory
Application    $APPL_TOP/admin/<CONTEXT_NAME>/out/<MMDDhhmm>

Database       $ORACLE_HOME/appsutil/out/<CONTEXT_NAME>/<MMDDhhmm>

To roll back an autoconfig session, execute:

               restore.sh