Previous	Next		Contents	Index	Navigation	Glossary	Library

The Oracle HRMS audit report performs this additional processing. You can use it as supplied or as an example of how to report on audit information. It can report on both datetracked and non-datetracked tables that have a numeric primary key.

Note: It can report on up to approximately 90 columns in datetracked tables and 80 columns in non-datetracked tables.

The report lists every change made to the table you select in the time period you specify when you run the report. You can restrict the reported changes to those made by a specified username. The changes are listed by date and time of the change. For each change, the report shows:

• the date and time of the change

• the user id who made the change

• the type of change

• the fields that changed and either their old values, or their new values, or both, depending on the type of change

Type of Change	Field Values Shown in the Report
Normal Insert (creates a non-datetracked record)	The non-null values in the new record.
Normal Update (updates a non-datetracked record)	The old and new values for all fields that changed.
Normal Delete (deletes a non-datetracked record)	The non-null values in the record that was deleted.
DT First Insert (creates a datetracked record)	The non-null values in the new record.
DT Update (date-effectively ends the last row on a datetracked record and creates a new row)	The old and new values of all fields that changed, and the new effective end date on the old row.
DT Correction (corrects a row of a datetracked record and does not change the effective dates)	The old and new values of all fields that changed, and the effective dates of the corrected row.
DT Replace (creates a new row on a datetracked record that replaces all rows that start after its start date)	The non-null values in the rows that were deleted, the new effective end date on the row preceding the new row, and the old and new values of all fields that changed.
DT Insert (creates a new row on a datetracked record that ends on the old effective end date of the preceding row)	The old and new values of all fields that changed, and the new effective end date on the row preceding the new row.
DT Purge (deletes all rows of a datetracked record)	The non-null values in all rows of the record that was deleted.
DT End Date (adds an effective end date to the last row of a datetracked record)	The new effective end date of the row.
DT All (sets a new effective end date on a row of a datetracked record and deletes all following rows)	The non-null values in the rows that were deleted, and the new effective end date on the last row.
DT Next (deletes a row of a datetracked record and uses its effective end date to set an new end date on the preceding row)	The non-null values in the row that was deleted, and the old and new effective end dates on the preceding row.
Table 1 - 23. Transaction Types in the Audit Report

To run the predefined audit report:

1. In the Submit Requests window, select Audit Report in the Name field.

2. Enter the Parameters field to open the Parameters window.

3. Select an audited table (that is, one in an audit group).

4. Select a value for the Initialization parameter:

• Yes means that the report removes obsolete data related to your selected table from the HR_AUDITS table and the HR_AUDIT_COLUMNS table. It populate the tables with new values, then reports on these.

• No means that the report runs on the existing data in the HR_AUDITS table and the HR_AUDIT_COLUMNS table.

• Refresh means that the report removes all obsolete data from the HR_AUDITS table and the HR_AUDIT_COLUMNS table. It populate the tables with new values, then reports on these.

5. If you only want to report on the changes made by one user, enter the username.

6. Enter start and end dates to limit the time period for reporting audit information.

7. Choose the Submit button.

See Also

Designing Your Own Audit Report