My Oracle Support Banner

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

Last updated on SEPTEMBER 17, 2020

Applies to:

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

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

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
References


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