Building a BIP Report for User Access Tracking — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!