I am currently seeking assistance in identifying a reliable method for tracking user activity within our IFS system. As part of our company policy, we need to maintain a comprehensive list of currently active users and their corresponding activity history within the system.
My initial investigation led me to the "fnd_client_logon_tab" table, which should ideally contain information about active users. However, to my surprise, the table appears to be empty, leading me to suspect a possible system error. Consequently, I am seeking clarification on whether this observed behavior indicates a technical issue that requires resolution.
Furthermore, I came across the "FND_SESSION_RUNTIME" view, which I hoped could serve as an alternative solution for tracking user activity. However, it appears that the records within this view have a short lifespan and rapidly disappear, rendering it ineffective for our intended purpose of monitoring user activity over time.
I am reaching out to inquire if there is an established, reliable approach or another suitable method to achieve the desired functionality. Our company's policy mandates the ability to ascertain which users are actively working within the IFS system at any given time, as well as maintaining a historical record of user activity.
Your expertise in this matter would be greatly appreciated. If there are any specific procedures, views, or tables that are better suited to accomplish our objectives, kindly provide guidance on how to access and utilize them effectively.
Thank you for your time and attention to this matter. I look forward to your valuable insights and assistance in resolving this issue promptly.