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