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:

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.

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

• Integrigy Whitepaper Guide to Auditing and Logging in Oracle E-Business Suite