Solved

how to know which users are logged in EE?

S
Rank
Userlevel 2
Badge +3

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

View original
This topic has been closed for comments

5 replies

Novishan Dissanayake
Rank
Userlevel 6
Badge +13

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

S
Rank
Userlevel 6
Badge +12

Hi Shecosa,

this might give you some insight as well.

 

regards,

Sahan

Charith Epasinghe
Rank
Userlevel 6
Badge +13

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

- Charith Epasinghe
S
Rank
Userlevel 2
Badge +3

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

S
Rank
Userlevel 2
Badge +3

Hi Shecosa,

this might give you some insight as well.

 

regards,

Sahan

Thank you very much!

Terms & ConditionsCookie settings