How do I view audit reports?

You can use the Audit Reports work area to view changes to the application data, such as the business objects that were created, updated, and deleted.

To view the history or to create a report, you must have a role with the View Audit History (FND_VIEW_AUDIT_HISTORY_PRIV) privilege assigned to it. For appropriate assignment of roles and privileges, check with your security administrator.

Audit Events

Transactional events in the application trigger the audit process based on the create, update, and delete operations. For events to trigger the audit process for the business objects, you must first enable the objects for auditing.

These are the events that trigger the audit process.

Transactional Event	When the Audit Activity is Triggered	Audit Report Content
Create	Whenever business object data is created and stored in the database	Name of the created object Name of the user who created the object Time of creation
Update	Whenever the existing business object data is updated	Both old and updated values of the object Name of the user who updated the object Time of updating
Delete	Whenever the existing business object data is removed from the database	The last value that the object attributes contained Name of the user who deleted the object

The event details are stored in the audit table. The attributes of the audited object data can be used in lookups and foreign keys to display values in the audit history. The application supports displaying the audited information according to the language settings configured.

For Oracle Fusion Middleware products, events such as failed sign-in attempts are used as triggers. In absence of an audit table, the information is stored in the sandbox and presented only in English.

Note: This topic focuses on the create, update, and delete event types available in Fusion Applications. For details on events used in the Oracle Fusion Middleware products, refer to the Oracle Fusion Middleware documentation.

See: Introduction to Oracle Fusion Middleware Audit Framework

View Audit Reports

You can view the audit report for the business objects that are enabled for auditing. Remember, to view the history, or to generate a report, you must have a role with the View Audit History (FND_VIEW_AUDIT_HISTORY_PRIV) privilege assigned to it.

1. Click Navigator > Tools > Audit Reports.
2. On the Audit Reports page, specify the search criteria.

   Here's what some of the search criteria are for:

   Search Parameter	Description
   Product	Displays all the products that are available for auditing. Note: The checkboxes in the Search Results section are enabled or disabled based on the product selected.
   Business Object Type	Narrows the search results to a specific business object, within the selected product. Enables the Show User-Related Details, Show Attribute Details, and Show Additional Object Identifier Columns checkboxes in the search results. Note: If you're generating the audit history report of a scheduled process, you must select the Business Object Type for your product. Otherwise, you'll get a blank report.
   Include child objects	Displays all the child objects that were listed for a business object when audit was set up. For example, a sales order object that contains several items as child objects. Objects are displayed at the immediate parent-child level only. To view the children at subsequent levels, select the child object as the business object type and search again.
   Include attachment details	This checkbox is displayed only when you select a business object associated with attachments. Displays additional event types for attachments in the Event Type list. These event types include the check-in, checkout, and download options for the attachments. Based on the selection, information about the check-in, checkout, and download actions done on attachments are displayed in the search results.
   Show User-Related Details	Displays the user ID. Note: For legacy data, also displays the name and ID of the impersonator who updated the objects during an impersonation session.
   Show Attribute Details	Enables the attribute list so that you can select either all attributes, or a specific attribute to view the changes. Based on the selection, the search results indicate whether an attribute is created, updated, or deleted, and the corresponding old and replaced values.
   Show Additional Object Identifier Columns	Displays the instances (contexts) in which the business object was used. The context values identify the objects and the transactions in which they were used. Each context is unique and assigns a unique description to the business object.

   For example, to get the audit report for all the insert and update operations of the business object type Item, belonging to the product Product Hub, use these search parameters:

   • From the Product list, select Product Hub.
   • From the Event Type list, select Object Data Insert and Object Data Update.
   • From the Business Object Type list, select Item.

   You can also specify any other details from the search criteria.

3. Click Search.

   In the Search Results section, you can see the audit report.

   Tip: You can also select the check boxes in the Search Results section and refine the search results to view more information.