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

- URL: https://www.integrigy.com/oracle-security-blog/oracle-e-business-suite-logging-and-auditing-page-access-tracking
- Published: 2014-03-07
- Type: Blog Post
- Products: Oracle E-Business Suite
- Focus areas: Auditing

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**

![EBS Configure Usage Statistics page with Web and Form access monitored and the most detailed capture level selected for each](https://www.integrigy.com/_astro/2331-1.ipSsqu-p.png)

**Figure 2 - Page Access Tracking Configuration Screen**

![Track Applications shuttle list moving EBS applications such as System Administration and Payments from Available to Tracked](https://www.integrigy.com/_astro/2331-2.B9vZtYmZ.png)

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

## References

- Integrigy Whitepaper [Guide to Auditing and Logging in Oracle E-Business Suite](https://www.integrigy.com/security-resources/guide-auditing-oracle-applications)
