Previous  Next          Contents  Index  Navigation  Glossary  Library

AuditTrail

You can choose to store a history of all changes users make to Payables database columns you specify. For example, you can audit the Invoice Amount column in the AP_INVOICES table so you can report on invoice amount adjustments, including the date and time of the change and the user who made the change. AuditTrail stores change information in a "shadow table" of the audited table. The shadow table stores audit data in an uncompressed but "sparse" format. You can then create reports for data in the shadow table.

For detailed information on auditing users and data, see the Audit chapter in the Oracle Applications System Administrator's Guide.

See Also

Reporting on Audit Trail Data


         Previous  Next          Contents  Index  Navigation  Glossary  Library