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