My Oracle Support Banner

Benefits Administration Error: INSERT or UPDATE Would Result in Duplicate Rows in a Table With a UNIQUE index (Doc ID 1297329.1)

Last updated on JANUARY 26, 2020

Applies to:

PeopleSoft Enterprise HCM Benefits Administration - Version 9 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the PSPBARUN batch process through Benefits> Manage Automated Enrollment> Events> Run Automated Benefits Processing, the following error occurs.

ERROR
-----------------------
20:02:53 1259031 0.031 0.031 #3 RC=805 EXE
20:02:53 1259032 0.000 0.000 #0 RC=805 ERR rtncd=805 msg=INSERT or UPDATE would result in duplicate rows in a table with a UNIQUE index
20:02:53 1259033 0.015 0.000 #65 RC=0 EPO error pos=0
20:02:54 1259034 0.954 0.000 #65 RC=0 Rollback

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to: Benefits> Manage Automated Enrollment> Events> Run Automated Benefits Processing
2. Enter Schedule ID
3. Run the process

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
Cause
Solution


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