Solved

how to know which users are logged in EE?


Userlevel 2
Badge +1

Hello,

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

Thank you in advance,

Regards,

icon

Best answer by Novishan Dissanayake 4 May 2021, 11:23

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

View original

5 replies

Userlevel 4
Badge +6

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

Userlevel 4
Badge +7

Hi Shecosa,

this might give you some insight as well.

 

regards,

Sahan

Userlevel 2
Badge +1

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!!

Userlevel 2
Badge +1

Hi Shecosa,

this might give you some insight as well.

 

regards,

Sahan

Thank you very much!

Userlevel 5
Badge +9

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") 

Reply