Audit Trail tables for tracking HR data changes
Hi All,
We have a requirement to track changes to employee fields (like job, name , salary etc.) and generate a report/output of it. The query that delivers the Date Track history in the application form, is useful only to a limited extent. So we were planning to either the standard Oracle audit tables or build a custom solution with business events and triggers.
We reviewed the Standard Oracle audit trail feature and while it is recording the changes , it is confusing in nature. It basically created multiple views for each column that is being tracked and has multiple tables like shadow tables with rowkey concept thrown in the mix. Did you have any similar requirement on your end and how did you manage it? Is there a way to make the standard oracle audit feature more readable and less confusing and avoid going the custom solution route?