Employee's Re-Submission of Elections in Benefits Enrollment Results in Error: A fatal PeopleCode SQL error occurred. SQL error in Exec. (2,280)
Last updated on JUNE 18, 2018
Applies to:PeopleSoft Enterprise HCM eBenefits - Version 9.2 and later
Information in this document applies to any platform.
Any employee who has at any time had a Life Event makes elections for Open Enrollment and submits them. When an employee reopens the Open Enrollment event, makes changes to the elections and attempts to submit them, the following error occurs:
A fatal PeopleCode SQL error occurred. Please consult your system log for details.
SQL error in Exec. (2,280) W3EB_ENR_SUMMARY.GBL.SavePostChange PCPC:1855 Statement:15
During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.
1. An employee who either has a current open Life Event or has had one in the past makes elections for Open Enrollment through Self Service and submits them (Navigation: Self Service > Benefits > Benefits Enrollment).
2. Employee reopens event, makes changes, and submits again.
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