Monday 8 January 2018

Audit Trail Enabling for Employee Tables


Enable Audit Trail Profile

Navigation: System Administrator à Profile à System
Now enter AuditTrail:Activate in Profile and click on Find.
Make sure it is enabled (Yes) at Site Level

Enable Audit For Schema
Navigation: System Administrator à Security à AuditTrail à Install
Now click F11 and enter HR in Oracle User Name field as shown below and press Ctl+F11
Make sure the check box is checked.

Audit Tables:
System Administrator à Security à AuditTrail à Tables
Now click F11 and enter PER_ALL_PEOPLE_F in Table Name field as shown below and press Ctl+F11

Now add the Columns which you need to do Auditing. For example I have added the below columns
1. PERSON_ID – Primary Key
2. EFFECTIVE_START_DATE – Primary Key
3. EFFECTIVE_END_DATE – Primary Key
4. LAST_NAME
5. EMAIL_ADDRESS
6. EMPLOYEE_NUMBER
7. FIRST_NAME
8. FULL_NAME

Now click F11 and enter PER_ALL_ASSIGNMENTS_F in Table Name field as shown below and press Ctl+F11

Now add the below columns
1. ASSIGNMENT_ID
2. EFFECTIVE_START_DATE
3. EFFECTIVE_END_DATE
4. POSITION_ID
5. JOB_ID
6. SUPERVISOR_ID

Audit Groups:
System Administrator à Security à AuditTrail à Groups
If the record already exists for Application Name “Human Resourcesthen modify it accordingly. If not then create as shown below.
Now add new record with below details and save
Application Name: Human Resources
Audit Group: XX HR Assignments 
Group State: Enabled
Audit Tables:
User Table Names
1. PER_ASSIGNMENTS_F
2. PER_PEOPLE_F

Request Submission:
Now go to View à Requests à Submit a New Request
Run the concurrent program “AuditTrail Update Tables






2 comments:

  1. I suppose if I had to pick a perfect article, it would be yours.  I know no article is perfect, but yours is as close as it gets.  Good job. Secure better rates with your carriers and make sure you pay only for what you get, with expert freight bill auditing software services by freight auditing tool.

    ReplyDelete
  2. Freight Audit Software: Fretron’s freight audits & payments help streamline audit-ready claim handling and management for faster settlements and reconciliation. Leverage intelligent workflows to automate your invoice generation and share it with vendors based on their specific payment cycles.

    ReplyDelete