INCREASE FORMS_TIMEOUT IN ORACLE R12
To implement the solution, please execute the following steps:
1. Edit the <CONTEXT_NAME>.xml file in $INST_TOP/appl/admin directory
2. Ensure that value of profile option “ICX: Session Timeout” and autoconfig variable “s_oc4j_sesstimeout” in context file match.
e.g. 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
3. Run autoconfig and retest the issue.
4. Migrate the solution as appropriate to other environments.
Ref: R12: Forms Timeout More Than 2 Hrs Is Not Working After R12 Upgrade (Doc ID 734077.1)