While Running Participation Process Life Events get error: ORA-06502: PL/SQL (Doc ID 2235557.1)

Last updated on JUNE 08, 2022

Applies to:

Symptoms

Error occurred running Participation Process -- Life Events

When uploading benefits enrollments, the following error is found:

ERROR
-----------------------
L_Emp_position = employee name w/characters, employee name-employee name w/characters
L_Emp_position = employee name w/characters, employee name-employee name w/characters
----------------------------------------------------------------------
Benefits Enrollment Upload Processing Information
----------------------------------------------------------------------
Lines Error : 1
----------------------------------------------------------------------
----------------------------------------------------------------------
Log messages for error records
----------------------------------------------------------------------
Person Number :xxxx Participant Name :xxxxxx Enrollment Type :Participant Enrollment. Error message :Error occurred running Participation Process -- Life Events. Error Message is -- ORA-06502: PL/SQL: numeric or value error: character string buffer too small Error line Id :30000000xxxxxxx

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Upload Benefits Enrollments > Enroll Batch_7 > Submit > Error in the log file

Cause

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