My Oracle Support Banner

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

Last updated on FEBRUARY 26, 2024

Applies to:

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


On :  12.2.4 version, Production, 17909898

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

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.

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

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