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.
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).
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