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:
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 |
Designing Your Own Audit Report
Previous | Next | Contents | Index | Navigation | Glossary | Library |