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 NOVEMBER 28, 2016

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms