Audit Is Not Working or Stopped Working From Specific Date For PAY_ELEMENT_ENTRIES_F PAY_ELEMENT_ENTRY_VALUES_F and PER_ALL_ASSIGNMENTS_F Tables (Doc ID 2965585.1)

Last updated on AUGUST 02, 2023

Applies to:

Symptoms

Audit is not working or stopped from specific date

Example: Audit stopped from 23-Jun-23 for the below tables.

PAY_ELEMENT_ENTRIES_F
PAY_ELEMENT_ENTRY_VALUES_F
PER_ASSIGNMENTS_F 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Enable the Audit. In this case, the customer is enabled the Audit sometime in 2013.

3. Did transaction on Element entry value form (PAY_ELEMENT_ENTRY_VALUES_F table).

4. Shadow table (Example: PAY_ELEMENT_ENTRY_VALUES_A) is not captured the transaction details.

Cause

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