Hello,
Is it possible to know what users are connected in real time in Enterprise Explorer?
Thank you in advance,
Regards,
Solved
how to know which users are logged in EE?
Best answer by Novishan Dissanayake
Hi
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
This topic has been closed for replies.
+13Hi
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
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!!
+13Normally 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.