Hello,
Is it possible to know what users are connected in real time in Enterprise Explorer?
Thank you in advance,
Regards,
Hello,
Is it possible to know what users are connected in real time in Enterprise Explorer?
Thank you in advance,
Regards,
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
Hi Shecosa,
this might give you some insight as well.
regards,
Sahan
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!!
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")
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.