HR Audit Report Show incorrect New Value

(Doc ID 1197203.1)

Last updated on OCTOBER 12, 2017

Applies to:

Oracle Human Resources - Version 12.0.6 and later
Oracle Application Object Library - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


On  12.0.6 version, e-Business Suite HR

Find the HR Audit Report shows incorrect New Value when audited field of a datetracked table are modified many times in Correction mode. 

The New Value column of the report always displays the current active value, instead of the value available at the time of the modification.

Expect to see correct value in the audit report, ever time a correction is made.

The issue can be reproduced at will with the following steps:

1. System Administrator -> Security: Audit Groups
2. Create a new Audit Group.
3. Add User Table Name: PER_PEOPLE_F, Save
4. Navigate to Security: Audit Tables
5. Query table name 'PER_ALL_PEOPLE_F'
6. Add FIRST_NAME to the column list, save
7. Run 'AuditTrail Update Tables' concurrent Request.  
8. Logout and Login as 'US Super HRMS Manager'
9. Run 'Audit Trail Update Datetracked Tables' concurrent request.
10. Navigate to People -> Enter and Maintain
11. Add a new employee with first_name 'Clarck', Save
12. Modify First_Name to 'Clarc' with correction mode, save
13. Modify First_Name to 'Clark' with correction mode, save
14. Run 'Audit Report' with following parameters:
   Table Name    : PER_ALL_PEOPLE_F
   Initialization: Refresh
   User Name: <UserName>
   Start Date: 26-APR-2010

15. Audit Report Shows the Following:

Timestamp               Column Name     Old Value       New Value
-------------------     -------------   ----------      ---------
2010-04-26 13:30:00     First Name       <null>         Clark
2010-04-26 13:31:10     First Name       Clarck         Clark
2010-04-26 13:32:01     First Name       Clarc          Clark

16. 'Audit Report' Should show the following:

Timestamp               Column Name     Old Value       New Value
-------------------     -------------   ----------      ---------
2010-04-26 13:30:00     First Name      <null>          Clarck
2010-04-26 13:31:10     First Name      Clarck          Clarc
2010-04-26 13:32:01     First Name      Clarc           Clark


HR_AUDITS and HR_AUDIT_COLUMNS tables has correct values, but the report does not show correct value, it always picks the most current value.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms