My Oracle Support Banner

Fusion Benefits: Open Enrollments: Script to Identify Population for Whom Override Has Been Performed (Doc ID 2827026.1)

Last updated on APRIL 14, 2024

Applies to:

Oracle Fusion Benefits Cloud Service - Version 11.13.21.10.0 and later
Information in this document applies to any platform.

Goal

We have Open enrollment started and the following error is seen when some employees try to submit their enrollment:

"There was a problem saving the election because another enrollment exists in the same element that this enrollment uses."

This issue as occurring ONLY for the employees for whom Override was done.
The overrides in question have created entry with end date as 31st Dec 4712. Hence when they enroll for next year via Open, it says the entry already exists.

Can you please share a SQL to identify this population so that we can avoid this issue?


Solution

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


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