Audit Trail in Oracle HRMS
| Print |
Written by Anil Passi
Tuesday, 19 December 2006
In our earlier article last month we covered Audit Trail in Oracle Apps. This article explains the extra steps needed to enable Audit Trail in Oracle HRMS Module.
Firstly read the article Audit Trail in Apps
Why are the steps for Auditing slightly different in Oracle HRMS?
This is mainly due to Date-Tracking feature which is HRMS/Payroll Specific.
For Auditing HRMS tables.....
Step 1. Check if Profile AuditTrail:Activate at site level
select fnd_profile.value('AUDITTRAIL:ACTIVATE') from dual ;
Step 2. Defined Audit Group and Audit Table in sysadmin
Step 3. Run process 'AuditTrail Update Tables' from System Administrator
Step 4. Run process 'Audit Trail Update Datetracked Tables' --From HRMS Superuser
Having followed the above steps will cause data to be created in shadow HR tables, names of these tables end with _A.
To move the data from 'shadow tables' into 'HR_AUDIT and HR_AUDIT_COLUMNS', you need to run process 'Audit Report' from HRMS Super User responsibility. The shortname of this program is PAYAUDIT.
Next you can check....
SELECT OLD_VALUE, NEW_VALUE FROM HR_AUDITS AUD, HR_AUDIT_COLUMNS ADC WHERE AUD.AUDIT_ID = ADC.AUDIT_ID AND AUD.TABLE_NAME = 'PER_ALL_PEOPLE_F' AND ADC.COLUMN_NAME = 'a column name being tested against'
That completes the Audit for tables in Oracle HRMS/Payroll.