Skip to main content

Hi ALL ,

I know that there is no direct query to monitor IFS application usage.

Need help please in setting up a custom event to gather ‘last activity’ date/time per user ?

not sure which table to use ?

 

Much appreciate

 

Hope you can use FND_CLIENT_LOGON_TAB by enabling history log

Follow the steps as mentioned below
How to setup history logs for FND_CLIENT_LOGON_TAB | IFS Community

Also please follow the below community thread
How to query IFS application usage | IFS Community

hope this information help you.


@Kelum Pradeep Kumara much appreciate your reply but I cannot really see how FND_CLIENT_LOGON_TAB can be used as it doesn’t store the open page/activity (or even table accessed by the user as shown below.

I also don’t have access to query  fnd_session_tab (having ‘table or view doesn’t exist’) even with IFSAPP account.


Reply