Oracle E-Business Suite Logging and Auditing: Page Access Tracking

Sign-On Audit only logs professional forms activity – it does not log Oracle Applications Framework (OAF) user activity.  Page Access Tracking is required to log OAF activity.  Once enabled, the level of logging needs to be set as well as flagging those applications to be logged and has negligible overhead.

To configure Page Access Tracking, use the following navigation: System Administration -> Oracle Applications Manager -> Site Map > Monitoring > Applications Usage Reports > Page Access Tracking.

Once enabled, Page Access Tracking requires two concurrent programs to be run.  The program Page Access Tracking Data Migration must be run to move data from the staging tables into the reporting tables.  This is usually done daily.  To purge data on a regular basis, run the program Page Access Tracking Purge Data.

The levels of logging are:

  • Session info
  • Session Info and Cookies
  • Session Info, Cookies and URL Parameters
  • Session Info, Cookies and All Parameters

Once configured, reports can be run for the following types of activity:

  • Session
  • Date
  • Form
  • User
  • Application

How to do you know if Page Access Tracking is enabled?

  • Check the system profile option JTF_PF_MASTER_ENABLED and if it set to TRUE for monitoring Web Access
  • Check the system profile option JTF_PF_LEVEL. This will be set for each Application. As well, it can be set for Responsibilities and users:

JTF_PF_LEVEL

Description

22

Session info

118

Session Info and Cookies

254

Session Info, Cookies and URL Parameters

126

Session Info, Cookies and All Parameters

 

What Tables Store Page Access Tracking Data?

The table below identified the tables used to store Page Access Tracking data. Remember that the concurrent programs Page Access Tracking Data Migration and Page Access Tracking Purge Data respectively insert data into and remove data from these tables.

Page Access Tracking Tables

JTF.JTF_PF_SES_ACTIVITY

JTF.JTF_PF_ANON_ACTIVITY

JTF.JTF_PF_APP_SUMM

JTF.JTF_PF_HOST_SUMM

JTF.JTF_PF_PAGE_SUMM

JTF.JTF_PF_USER_SUMM

Figure 1 - Page Access Tracking Configuration Page

 

Figure 2 - Page Access Tracking Configuration Screen

If you have questions, please contact us at info@integrigy.com

 -Michael Miller, CISSP-ISSMP

References

 Share this post

Subscribe to RSS

Add us to your favorite news reader.

Follow on Twitter

Get the latest updates.