Audit Trail Is Not Displaying Data For Per_pay_proposals Table (Doc ID 2136127.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Human Resources - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On :  12.2.4 version, Production, 17909898 R12.HR_PF.C.delta.5

ACTUAL BEHAVIOR  
---------------
Setup Audit Trail on per_pay_proposals table.
Find that even after changing salary basis on one assignment, the audit report  shows no data.

EXPECTED BEHAVIOR
-----------------------
Expectation are that after setting up audit trail for per_pay_proposals and changed made in employee salary to be reflected in the audit table.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Step 1) Navigate to System Administrator> Audit Trail> Install> Enabled Audit for HR
Step 2) Open Audit Groups>  Add a new Audit Group  for  PER_PAY_PROPOSALS table
Step 3) Open Audit Tables>  Add the column PROPOSED_SALARY_N in  PER_PAY_PROPOSALS table
Step 4) Run the concurrent Program “AuditTrail Update Tables”
Step 5) Navigate to People: Enter and maintain  and add  the basic salary for an employee.
Step 6) Run report: Audit trail Report for Audit Group Validation with parameters: Audit group name: Basic Salary

The salary change is not captured in the file

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot confirm the correct person(s) made salary changes..

Cause

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