My Oracle Support Banner

Base Benefits Enrollment: Fatal PeopleCode SQL error SQL error is Exec. (2,280)FUNCLIB_RETRO.INSRT_RTRODED_RQST.FieldFormula Name:insrt_rtroded_rqst PCPC:3223 (Doc ID 2584838.1)

Last updated on SEPTEMBER 29, 2020

Applies to:

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

Symptoms

When multiple users are correcting savings, Life, health or disability enrollments at the same time, sometimes this error occurs:


ERROR
-----------------------
Fatal PeopleCode SQL error

SQL error is Exec. (2,280)FUNCLIB_RETRO.INSRT_RTRODED_RQST.FieldFormula Name:insrt_rtroded_rqst PCPC:3223
Called from:FUNCLIB_RETRO.UPDATE_RQST.FieldFormula Name:updt_rtroded_rqst Statement:204
Called from:LIFE_ADD_BEN.EMPLID.SavePostChange Statement:38


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Multiple Users enter historical changes to Benefits Enrollments.  Navigation: Benefits > Enroll in Benefits

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
Symptoms
Cause
Solution


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