Enrollment Snapshot Process (BEN100A.sqr) Fails With Error: Cannot insert duplicate key row in object 'dbo.PS_BN_SNAP_PLAN' with unique index 'PS_BN_SNAP_PLAN'. (Doc ID 2965962.1)

Last updated on AUGUST 07, 2023

Applies to:

PeopleSoft Enterprise HCM Benefits Administration - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Benefits Enrollment snapshot (SQR BEN100A.sqr) fails with the following error:ERROR

Steps to reproduce the issue:

     1. Run the Refresh Benefit Snapshot process (Navigation: Benefits > Interface with Providers > Refresh Benefit Snapshot).
     2. Monitor the process in Process Monitor (Navigation: PeopleTools > Process Scheduler > Process Monitor).
     3. When the process fails, check the .out file (Navigation: Details link > View Log/Trace link).

Changes

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

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

Enrollment Snapshot Process (BEN100A.sqr) Fails With Error: Cannot insert duplicate key row in object 'dbo.PS_BN_SNAP_PLAN' with unique index 'PS_BN_SNAP_PLAN'. (Doc ID 2965962.1)

Applies to:

Symptoms

Changes

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!