Building a BIP Report for User Access Tracking

Summary:

Dear Customer Connect Community,

I hope this message finds you well.

I am looking to create a BIP Report using standard SQL to track user access within specific areas of a system. The report should display all instances of user entry into sections or pages.

From my research, I understand that it may be possible to achieve this by leveraging the following tables:

• FND_SESSIONS
• FND_SESSION_ATTRIBUTES
• FND_SESSION_ATTRIBUTES_SETS
• FND_SESSION_NAMESPACES
• FND_SESSION_ROLE_SETS
• FND_SESSION_TEMPLATES
• FND_SESSION_USERS
• FND_SESSION_USER_ACTIVITY

Before proceeding, I would like to confirm if anyone in the community has experience building a similar report. Specifically, I’m curious to know: