Have any question?
+2 0100 62 62 837
[email protected]
Register Login

Login with your site account

Lost your password?

Not a member yet? Register now

AppsLead | Learn Oracle From The LeadersAppsLead | Learn Oracle From The Leaders
  • Home
  • Courses
    • About Courses

      • Free Training
        • Oracle ebusiness suite Free
        • Oracle Fusion Free
      • Online Live Training
        • Oracle ebusiness suite
        • Oracle Fusion
        • Oracle Database
        • Java & Middleware
      • All Training Courses
      • Training Schedule
      • Register For Live Course
      • Join Our Team
      • Exam Request
  • Blog
    • Oracle ebusiness Suite
      • Oracle Financial
      • Oracle HCM
      • Oracle SCM
    • Oracle Fusion
      • Fusion Financial
      • Fusion HCM
    • Our Authors
    • Be an Author
  • Schedule
  • FAQs
  • About Us
    • About Us
    • Our Services
    • Our Authors
  • Contact Us
  • Home
  • Courses
    • About Courses

      • Free Training
        • Oracle ebusiness suite Free
        • Oracle Fusion Free
      • Online Live Training
        • Oracle ebusiness suite
        • Oracle Fusion
        • Oracle Database
        • Java & Middleware
      • All Training Courses
      • Training Schedule
      • Register For Live Course
      • Join Our Team
      • Exam Request
  • Blog
    • Oracle ebusiness Suite
      • Oracle Financial
      • Oracle HCM
      • Oracle SCM
    • Oracle Fusion
      • Fusion Financial
      • Fusion HCM
    • Our Authors
    • Be an Author
  • Schedule
  • FAQs
  • About Us
    • About Us
    • Our Services
    • Our Authors
  • Contact Us

Blog

  • Home
  • Blog
  • Oracle HRMS Audit Trail – Audit Changes in HRMS

Oracle HRMS Audit Trail – Audit Changes in HRMS

  • Posted by Sameh Bakkar
  • Categories Blog
  • Date March 29, 2011
  • Comments 0 comment
In this article I will explain 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 tables. In this example we will see how changes to First Name and Last name of a person are being audited.
Also keep in you concederation that AuditTrail only in a limited capacity.On the following tables: PER_ALL_PEOPLE_F PER_ALL_ASSIGNMENTS_F PAY_ELEMENT_ENTRY_VALUES_F PAY_ELEMENT_ENTRIES_F PAY_PERSONAL_PAYMENT_METHODS_F PAY_EXTERNAL_ACCOUNTS However we do not audit all columns. 1- Check if Profile AuditTrail:Activate at site level to be Yes select fnd_profile.value(‘AUDITTRAIL:ACTIVATE’) from dual ; 2- Navigate to system administrator >> Security >> AuditTrail >> Install 1 after that you have to query on Oracle Username HR and then enable the Audit Enabled check-box as below screen. 2 3-Defined Audit Group: Navigate to Audit Group screen in System Administrator, and create an “Audit Group” as show below. 3 4- From System Administrator responsibility, add the desired columns that you wish to audit upon on table PER_ALL_PEOPLE_F 4 5- From System Administrator, Run Concurrent program “AuditTrail Update Tables” .
  • This request will do the following:
      • creates database triggers on your audited tables
      • creates one shadow table for each audited table, to contain the audit information
      • builds special views on non-datetracked tables, which you can use to retrieve your audit data for reporting
6- login to HRMS Superuser and run concurrent program “Audit Trail Update Datetracked Tables”
  • This request will do the following:
      • creates an index on the shadow table
      • creates the function _TT and the procedure _VP, which extracts information from the shadow table when you run the predefined audit report
and you can run this process manually or put it as a scheduled process (Manually is recommended) Note: This again is a one off step that must be implemented when you have made changes to Audit Groups/Tables/Column lists. 7- Change the name of a person from “Sameh” to “Mohamed”, from person entry screen. 5 8- Run concurrent program “Audit Report” From Oracle HRMS Superuser responsibility and put this parameters: A- Table Name: Per_All_People_F B- initialization:   Yes By running the process “Audit Report”, data from shadow Audit tables [ _A ] will be moved into HRMS Audit Tables. 9- query the data from HR_AUDITS and HR_AUDIT_COLUMNS. 6 7 Also you can check using this query: SELECT      OLD_VALUE, NEW_VALUE FROM        HR_AUDITS AD   ,   HR_AUDIT_COLUMNS AC WHERE      AD.AUDIT_ID = AC.AUDIT_ID AND         AD.TABLE_NAME = ‘PER_ALL_PEOPLE_F’ AND         AC.COLUMN_NAME = ‘FIRST_NAME’ ;      

Tag:Audit Changes in HRMS, Oracle HRMS, Oracle HRMS Audit Trail

  • Share:
Admin bar avatar
Sameh Bakkar
Sameh Bakkar has over 15 years Oracle Applications implementation experience (EBS/Fusion) and he is an Oracle authorized trainer. He has in-depth technical and Functional knowledge of Oracle Applications and Oracle HCM Cloud. Sameh has excellent experience in Team management, Man Power and resource planning, and Pre-Sales management Process. Additionally he has also given Best Practices seminars on Oracle e-business suite and Oracle Fusion.

Previous post

HRMS Previous Employer and Jobs API
March 29, 2011

Next post

How to make a multi Language Message in a (Form-Based Personalization)
30 March, 2011

You may also like

  • Entering Request for Quotations (RFQ)
    19 June, 2012
  • HRMS Assignment Migration – API
    9 March, 2011

Leave A Reply Cancel reply

Your email address will not be published. Required fields are marked *

Search

Categories

  • Blog
  • Fusion HCM
  • Oracle ebusiness Suite
  • Oracle Financial
  • Oracle Fusion
  • Oracle HCM
  • Oracle SCM

Latest Courses

R12.x Oracle E-Business Suite Essentials for Implementers

R12.x Oracle E-Business Suite Essentials for Implementers

Free
R12.x Oracle HRMS Work Structures Fundamentals

R12.x Oracle HRMS Work Structures Fundamentals

Free
R12.x Oracle Payroll Fundamentals

R12.x Oracle Payroll Fundamentals

Free
AppsLead | Learn Oracle From The Leaders

+2 0100 62 62 837

[email protected]

Company

  • About Us
  • Blog
  • Contact Us

Links

  • Events

Copyright © 2017 AppsLead, All rights reserved. Developed by ECDSCS Co.

  • Privacy
  • Terms
  • Sitemap