My Oracle Support Banner

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

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
Symptoms
Changes
Cause
Solution
References


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