Setting Up an Audit Trail in Planning
Setting Up an Audit Trail in Planning
This tutorial covers how to use auditing reports to track user data activity in a data form in Planning 11.1.1.
Approximately 20 minutes.
This tutorial covers the following topics:
Place the cursor over this icon to load and view all the screenshots for this tutorial. Caution: This action loads all screenshots simultaneously, so response time may be slow depending on your Internet connection.)
Note: Alternatively, you can place the cursor
over an individual icon in the following steps to load and view only the screenshot
associated with that step. You can hide an individual screenshot by clicking it.
This tutorial covers how to set up audit trails in Planning.
Back to Topic List
You are the Planning administrator at your company. Your management team asked you to provide them with auditing reports that track when users enter and modify data in Planning data forms.
After setting up change tracking, you verify data changes in the HSP_AUDIT_RECORDS table.
Back to Topic List
Before starting this tutorial, you should:
| 1. |
Have administrator access to Planning applications.
|
| 2. |
Have access to Workspace and Planning.
|
| 3. |
Have access to query Planning relational database tables. In this case, you use Oracle SQL Developer.
|
Back to Topic List
To enable Planning audit reports, perform the following steps:
1. |
Log on to Workspace.
|
2. |
Select Navigate > Applications > Planning > [Planning application].
|
| 3. |
Select Administration > Reporting.
|
| 4. |
Select the Auditing tab.
|
| 5. |
Click Close.
|
| 6. |
In the view pane, expand the Forms node. Under Forms, click a folder name to display its content, and click a data form.
|
| 7. |
Click an unlocked cell, enter data, and click Save.
|
Back to Topic List
To use Oracle SQL Developer to view and clear audit reports, perform the following steps:
1. |
From your desktop, select Start > Programs > Oracle - OraDb11g > Application Development > SQL Developer.
|
| 2. |
Expand nodes to locate Planning relational database tables.
|
| 3. |
Select the HSP_AUDIT_RECORDS table and click the Data tab to display audit history.
In this example, data changes applied to all affected cells are posted to the table.
|
| 4. |
From the Data tab, click the first cell in row 1 and press Ctrl + A to select all rows.
|
| 5. |
Click Delete Selected Row(s).
|
| 6. |
Click Commit Changes.
|
| 7. |
All records are deleted.
|
Back to Topic List
In this tutorial, you learned how to:
 |
Enable auditing |
|
View and clear audit reports in SQL Developer |
Back to Topic List
|
To learn more about setting up Planning audit trails, refer to additional OBEs on the OTN Web site |
Back to Topic List
Place the cursor over this icon to hide all screenshots.
| 
Bookmark
