Audit Report Returns No Data For PAY_ELEMENT_ENTRIES_F Table (Doc ID 2135797.1)

Last updated on DECEMBER 09, 2022

Applies to:

Symptoms

After setting up auditing for the table PAY_ELEMENT_ENTRIES_F, and adding an element to an employee, when running the audit report it is observed that the report returns no data


Steps to be Reproduce:
The issue can be reproduced at will with the following steps:
1. Set up auditing on table pay_element_entries_f
2. Add a new element to an employee
3. Run the audit report on the table with initialization=Y
4. Observe that no data is returned

OBSERVATION

It is observed that there are rows in the shadow table pay_element_entries_f_a, but there are no rows in hr_audits and hr_audit_columns after running the report

It is also observed that auditing on table per_all_people_f does work and data is reported when the audit report is run for this table

Changes

Cause

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