Inactive frmweb sessions

[kumar]

Hello erman,

We have few inactive forms sessions from AP/INV modules in database.How can we get rid of them from showing up in v$session.The output ordered by last_Call_et/60 desc


sql  used:
select sid,module,program,last_Call_et/60,logon_time from gv$session where program like 'frmweb%' order by LAST_CALL_ET/60 desc



       SID MODULE                                   PROGRAM                                            LAST_CALL_ET/60 LOGON_TIME
---------- ---------------------------------------- -------------------------------------------------- --------------- ------------------
      1423 e:CE:frm:FNDSCSGN                        [e-mail] (TNS V1-V3)                 351.733333 17-DEC-19
       231 e:SQLAP:frm:FNDSCSGN                     [e-mail] (TNS V1-V3)                     332.15 17-DEC-19
       238 e:SQLAP:frm:APXINWKB                     [e-mail] (TNS V1-V3)                 329.783333 17-DEC-19
      1043 e:AR:frm:FNDSCSGN                        [e-mail] (TNS V1-V3)                      173.7 17-DEC-19
      1032 e:AR:frm:ARXRWMAI                        [e-mail] (TNS V1-V3)                 172.833333 17-DEC-19
      1424 e:INV:frm:FNDSCSGN                       [e-mail] (TNS V1-V3)                      84.55 17-DEC-19
       639 e:SQLAP:frm:FNDSCSGN                     [e-mail] (TNS V1-V3)                 80.5166667 17-DEC-19
      1443 e:SQLAP:frm:FNDSCSGN                     [e-mail] (TNS V1-V3)                 80.0833333 17-DEC-19
       669 e:SQLAP:frm:APXINWKB                     [e-mail] (TNS V1-V3)                 75.8833333 17-DEC-19
        41 e:AR:frm:FNDSCSGN                        [e-mail] (TNS V1-V3)                 75.8833333 17-DEC-19
        66 e:AR:frm:ARXRWMAI                        [e-mail] (TNS V1-V3)                 75.3333333 17-DEC-19

       SID MODULE                                   PROGRAM                                            LAST_CALL_ET/60 LOGON_TIME
---------- ---------------------------------------- -------------------------------------------------- --------------- ------------------
       824 e:AR:frm:FNDSCSGN                        [e-mail] (TNS V1-V3)                 68.0333333 17-DEC-19
      1432 e:INV:frm:INVTTMTX                       [e-mail] (TNS V1-V3)                 67.2666667 17-DEC-19
       437 e:INV:frm:RCVRCERC                       [e-mail] (TNS V1-V3)                      54.55 17-DEC-19


Thank you,
kumar

[ErmanArslansOracleBlog]

what is the value of  "ICX: Session Timeout" profile option?
And what is the value of "s_oc4j_sesstimeout" in the apps tier context file?

Those 2 should match and they must be set according to your requirements.

Note that, this timeout works only for the servlet mode. Are you using servlet or socket mode forms?

Note that If you are sure that these session are idle and they have been idle for a long time, then you may kill them ->How to Kill Inactive Sessions Based on the Information in the Monitor User Form?(Doc ID 103516.1)

[satish]

Hello erman,
 
We also have similar situation,we are in r12.2...
For socket mode,do we have to kill them manually?

Thank you

[ErmanArslansOracleBlog]

According to the note "R12: Forms Timeout Setting Of More Than 2 Hours Is Not Working After R12 Upgrade (Doc ID 734077.1)",  you can't get) the advantage of using the usual timeout configuration for the socket mode.. ( It is stated as -> "This note is correct for servlet mode and the default mode. This will not work in socket mode. "

You may kill those sesssions, or you may consider using DCD with EBS.