My Oracle Support Banner

Benefits Snapshot Error: Cannot Insert Duplicate Key Row in Object 'PS_BN_SNAP_PLAN' with Unique Index 'PS_BN_SNAP_PLAN'. (Doc ID 634647.1)

Last updated on JUNE 13, 2022

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 8.8 SP1 to 9.1 [Release 8.8 to 9]
Information in this document applies to any platform.

Symptoms

Running the BEN100A (benefits snapshot process), the following error occurs: "SQL Status =  2601, SQL Error  = [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'PS_BN_SNAP_PLAN' with unique index 'PS_BN_SNAP_PLAN'."

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.