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

Last updated on JULY 23, 2016

Applies to:

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

Symptoms

On : 12.1 HRMS RUP 7 version, in all instances,

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

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