My Oracle Support Banner

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

Last updated on DECEMBER 09, 2022

Applies to:

Oracle Payroll - Version 12.1 HRMS RUP7 and later
Information in this document applies to any platform.


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


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




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.