Skip to main content

Hello,

Is it possible to know what users are connected in real time in Enterprise Explorer?

Thank you in advance,

Regards,

Hi @shecosa,

 

You can log in to the database directly and query the table ‘FND_CLIENT_LOGON_TAB’ to see the logged-in user sessions.

 

Cheers!

Novishan


Hi Shecosa,

this might give you some insight as well.

 

regards,

Sahan


Hi @shecosa,

 

You can log in to the database directly and query the table ‘FND_CLIENT_LOGON_TAB’ to see the logged-in user sessions.

 

Cheers!

Novishan

Thank you very much!!


Hi Shecosa,

this might give you some insight as well.

 

regards,

Sahan

Thank you very much!


Normally oracle table "FND_CLIENT_LOGON_TAB" gets and entry when a user successfully login to IFS Application. And that gets cleared when the user gets off from the application.Querying on FND_CLIENT_LOGON_TAB gives you all the currently logged in users to the system. However, it should be noted that FND_CLIENT_LOGON_TAB removes the user from that table if the user has been idle for a long time.

1. Login to database using PLSQL Developer or any other SQL developer tool using application owner account (IFSAPP).
2. Query "fnd_client_logon_tab" in the database (use SQL statement "SELECT * FROM fnd_client_logon_tab")