Multiple Audit Rows Are Created During a Change to an Employee's Savings Plan Enrollment (Doc ID 2794266.1)

Last updated on AUGUST 23, 2023

Applies to:

Symptoms

Creating an audit for Savings Plan enrollments (PS_SAVINGS_PLAN/PS_AUDIT_SAVS_PLAN) causes audit rows with Action = C for all 4x Plan Types associated to the employee.

Example: A new savings plan enrollment for Plan Type 46 was inserted for an employee with enrollments in other 4x Plan Types.  In the audit table there were additional C rows added for all of the other 4x plan type enrollments.

Replication Steps:

1. Select an active Employee with an enrollment in a savings plan tied to 40 plan type but not Plan Type 46.  Navigation: Benefits > Enroll In Benefits > Savings Plans.

2. Insert a new Plan Type 46 enrollment row for the employee and save.

Results are that the Audit table gets two rows added, one with the action = A (correct row) for plan type 46 and one with Action=C(incorrect row) for plan type 40, however, Plan Type 40 was never touched so there should not be any row for it in the audit record.

Changes

Cause

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