Skip to main content
Question

How to capture IFS Session's Logoff timestamp

  • September 24, 2020
  • 4 replies
  • 262 views

Srikanth
Superhero (Partner)
Forum|alt.badge.img+18

Hi,

Is there any way to capture the timestamp once Users close their IFS IEE Session?

We are trying to create a Quick Report to calculate total login time for IFS Users.

I can capture the LOGON time using IFS or Oracle views. However, capturing LOGOFF time is proving to be challenging as IFS doesn’t disconnect the backend Oracle session immediately, so there is no LOGOFF event recorded at the point of session disconnection. 

Any help or pointers in this regard is appreciated.

TIA,

Sri

4 replies

paul harland
Superhero (Employee)
Forum|alt.badge.img+24

have you tried history logging on FND_CLIENT_LOGON_TAB


Srikanth
Superhero (Partner)
Forum|alt.badge.img+18
  • Author
  • Superhero (Partner)
  • 291 replies
  • September 24, 2020

I looked at that table and it only has a LOGON but no LOGOFF timestamp, which is the one I am after.


durette
Superhero (Customer)
Forum|alt.badge.img+19
  • Superhero (Customer)
  • 525 replies
  • September 24, 2020

You can use the history log both ways.

 

   SELECT logons.username,
          logons.time_stamp  AS logon_date,
          logoffs.time_stamp AS logoff_date
     FROM history_log_tab logons
LEFT JOIN history_log_tab logoffs
       ON logoffs.keys         = logons.keys
      AND logoffs.table_name   = logons.table_name
      AND logoffs.lu_name      = logons.lu_name
      AND logoffs.history_type = '3'
    WHERE logons.table_name   = 'FND_CLIENT_LOGON_TAB'
      AND logons.lu_name      = 'FndClientLogon'
      AND logons.history_type = '1'
 ORDER BY logons.time_stamp DESC;

 


dsj
Superhero (Partner)
Forum|alt.badge.img+22
  • Superhero (Partner)
  • 828 replies
  • September 25, 2020

I doubt FND_CLIENT_LOGON_TAB can be used to accurately capture logoffs.

Record from the table is deleted even when the user is idle.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings