To enable auditing in Oracle Human Resources is merely a 15minutes job.
Please find below, a step by step example that enables Auditing in Oracle HRMS.
This article is a proof of concept for auditing in Oracle HRMS, as it ends with showing the data from HR_AUDITS and HR_AUDIT_COLUMNS.
Note that all the audit screens in System Administrator responsibility are located in Menu Path /Security/AuditTrail/Groups
Step 1. From system administrator, Enable Auditing for Oracle HRMS Application.
To do this, navigate to AuditTrail Install in System Administrator.
Next, query on Oracle Username HR and then enable the Audit Enabled check-box.
Step 2. From system administrator, Create a audit group that contains PER_ALL_PEOPLE_F
In this proof of concept, we will see how changes to First Name and Last name of a person are being audited.
Navigate to Audit Group screen in System Administrator, and create an "Audit Group" as show below.
Step 3. From System Administrator responsibility, add the desired columns that you wish to audit upon on table PER_ALL_PEOPLE_F
Step 4. Again in System Administrator, Run Concurrent program “AuditTrail Update Tables”
Step 5. Next, login to HRMS Superuser and run concurrent program “Audit Trail Update Datetracked Tables”
This again is a one off step that must be implemented when you have made changes to Audit Groups/Tables/Column lists.
Step 6. Change the name of a person from Aneel to Anil, from person entry screen.
Step 7. Schedule the concurrent program “Audit Report” Oracle HRMS Superuser
In this example, I am passing it parameter PER_ALL_PEOPLE_F
By running the process “Audit Report”, data from shadow Audit tables [ <table_name>_A ] will be moved into HRMS Audit Tables.
Step 8. Next, query the data from HR_AUDITS and HR_AUDIT_COLUMNS
Comments
Nice POC, but i just tried these steps with the per_all_assignm ents_f table and as expected it was auditing the ID(s) i.e POSITION_ID , JOB_ID etc the ID(s) changes will not be useful when presented in the Standard Audit Report to the users. Can you please provide any tips on how to show the e.g. POSITION_NAME , JOB_NAME when changes are made to per_all_assignm ents_f in any standard oracle Audit reports? or will we have to write our own oracle reports for this?
Thanks,
Omar
It is very good Explaination specially the table side of the Audit (for the people at technical level). The Best part it was very systematic but when I tried to save to .pdf format, the screen shot does not get saved. I wonder why ! as it is only saving 1 page.
Are there only two tables as Hr_audit and Hr_audit_column s will get affected for parent child relationship and not more than that ?
Rgds,
Wahida
You might need to do your own joins to report in that manner. But the data will all there for youe
Hi Wahida
Yes these two tables will give you all that you required
Thank s
anil
I am new in apps. can u send me the documentation of workflow from basic.
thanks
ved
its not related to audit report.
i have a doubt and didnt know where to ask so....
i would like to know what is salary hold and release salary hold elements do and how do we write a fast formula for it...and which cases do we run these elements.
Than ks
ramya
thank you
This is very good works but this is to audit change. In today world, we also need to audit who can view the HR information as well.
What is your thought on that and any idea on how to restrict and audit the HR information.
Restricti on on who can see the data can be achived with a combination of HRMS Security Profile and tasks flows.
Thanks,
Anil Passi
I had a query relaed to audit Trail.I have auditing on column First name(varchar2 (150)) and last name(Varchar2 (150)) in per_all_people_ f.Also, the first name column size is varchar 20 in Per_all_people_ f_a, because of which I am getting an error while terminating the employee.So I have changed the width from varchar2 (20) to varchar2 (150) in per_all_people_ f_a table.
Due to this I was able to terminate the employee and I didn't get error which I was getting previously while terminating the employee.I just want to know what are the impacts of changing the column width??
Thanks in advance,
Manis h
Here i am facing problem with Audit Train - HRMS. As you mentioned i followed all the steps, but data was not reflecting in PER_ALL_PEOPLE_ F_A , HR_AUDITS, HR_AUDIT_COLUMN S. when i check per_all_people_ f triggers are not firing. I try to create seeded triggers where i copied from another instance but they are not saving in DB.
Kindly pass your comments on this....
Thank s,
Ananth Yasaswi G
Associate Consultant - oracle apps
Bangalore
RSS feed for comments to this post