1. Implementing Risk Management
  2. Run Audit Reports

Run Audit Reports

Audit reports capture changes made after auditing is enabled.

By default, each record in a report shows the following:

  • The date and time a change was made.
  • The user who made the change.
  • The event (whether an item is inserted, deleted, or updated).
  • The type of business object affected by the change.
  • A description (the name of the item that's been changed.

To run a report:

  1. Select Navigator > Tools > Audit Reports. This is available to you if you're assigned a role with the View Audit History privilege (FND_VIEW_AUDIT_HISTORY_PRIV).

  2. In a Search area, select Risks and Controls in the Product field. In a Date field, define the period you want the report to cover, such as "Before" and the current date. You can also set other search criteria. For example:

    • If you select a value in the Business Object Type field, you limit the report results to records of changes to that object (for example, advanced controls). However, you also activate checkboxes that enable you to refine the information each record presents.

    • You can use an Event Type field to have the report return records of all changes, or only of inserts, updates, or deletions.

  3. Click the Search button. A Search Results area displays the change records you've searched for.

  4. If your search criteria included a Business Object Type value, click any of three checkboxes to expand the information each record displays.

    In particular, a Show Attribute Details option adds columns that identify the attribute that has changed in each record and display the old and new values of that attribute. When you click the Show Attribute Details checkbox, a field appears. In it, you may do either of the following:

    • Select the value All Attributes. The report then displays the attribute, old value, and new value for every record your search criteria identified.

    • Search for and select a single attribute. The report then filters records returned by your search criteria to include only those involving the attribute you select. It displays the attribute, old value, and new value for each of those records.

Click the related-topic link for more information on audit reporting.

Related Topics