EPY: Audit Table for Secondary Record Causes "Data Being Added Conflicts With Existing Data" Error if Multiple Rows Entered
(Doc ID 2767823.1)
Last updated on APRIL 17, 2021
Applies to:PeopleSoft Enterprise HCM ePay - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise HCM Payroll for North America - Version 8.9 to 9.2 [Release 8.9 to 9]
Information in this document applies to any platform.
After adding an audit record for DIRECT_DEPOSIT and DIR_DEP_DISTRIB records, when entering more than one Direct deposit file, the insert fails for the employee with the error below.
The issue can be reproduced at will with the following steps:
1. Create Audit record for the Parent and Secondary records.
Example: DIRECT_DEPOSIT and DIR_DEP_DISTRIB
2. Use recommendation of only using the audit fields as a key as described in PeopleBooks
3. Employee enters more than one detail row for their direct deposit via Self Service (or administrator updates the review Direct Deposit) to have more than one unique row (in this case 4 unique rows)
4. Error occurs upon save
Audit Tables created for a primary record and secondary record that can have multiple rows.
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