HR Audit Report Show incorrect New Value (Doc ID 1197203.1)

Last updated on OCTOBER 12, 2021

Applies to:

Symptoms

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.

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

STEPS
-----------------------
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 'xxxY', Save
12. Modify First_Name to 'xxx' with correction mode, save
13. Modify First_Name to 'xxxY' 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>         xxxY
2010-04-26 13:31:10     First Name       xxxY       xxxY
2010-04-26 13:32:01     First Name       xxxY       xxxY


16. 'Audit Report' Should show the following:

Timestamp               Column Name     Old Value       New Value
-------------------     -------------   ----------      ---------
2010-04-26 13:30:00     First Name      <null>         xxxY
2010-04-26 13:31:10     First Name      xxxY           xxx
2010-04-26 13:32:01     First Name     xxx           xxxx


Note:

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.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.