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:
|Viewing and Clearing Audit Reports in SQL Developer|
Click icon to show all screenshots
Note: Alternatively, you can click an individual icon (or image) associated with each step to view (or hide) the screenshot associated with that step.
This tutorial covers how to set up audit trails in Planning.
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.
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.|
To enable Planning audit reports, perform the following steps:
Log on to Workspace.
Select Navigate > Applications > Planning > [Planning application].
Select Administration > Reporting.
Select the Auditing tab.
In the view pane, expand the Forms node. Under Forms, click a folder name to display its content, and click a data form.
Click an unlocked cell, enter data, and click Save.
To use Oracle SQL Developer to view and clear audit reports, perform the following steps:
From your desktop, select Start > Programs > Oracle - OraDb11g > Application Development > SQL Developer.
Expand nodes to locate Planning relational database tables.
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.
From the Data tab, click the first cell in row 1 and press Ctrl + A to select all rows.
Click Delete Selected Row(s).
Click Commit Changes.
All records are deleted.
In this tutorial, you learned how to:
|View and clear audit reports in SQL Developer|
To learn more about Planning, refer to additional OBEs.
More Middleware Downloads