My Oracle Support Banner

Base Benefits Error: Data Being Added Conflicts with Existing Data (18,2) (Doc ID 1396639.1)

Last updated on OCTOBER 02, 2018

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 9.1 and later
Information in this document applies to any platform.


When language is different that English and dependent row is deleted the row from PS_DEP_BEN_LNG table is NOT deleted. Because the system deletes the row from the PS_DEP_BEN table, but it does not delete the row from the PS_DEP_BEN_LNG table, a duplicate error occurs later if a new dependent with the same id is added.

Replication steps:
1. Log in Spanish or other language then English
2. Main Menu > Workforce Administration > Personal Information > Personal Relationships > Dependent Information select an employee.
3. Insert the data of dependent/beneficiary for Dependent/Beneficiary ID: 01 and save
4. Delete Dependent/Beneficiary ID: 01 and save
5. Go to search page and select the same emplid and try to add again data for Dependent/Beneficiary ID: 01 and save.
6. The error message will appear. Data Being Added Conflicts with Existing Data (18,2).


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

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