My Oracle Support Banner

Fusion Benefits: Open Enrollments: Evaluate Scheduled Event Participation Errors Out with ORA-06502: PL/SQL: numeric or value error: NULL index table key value (Doc ID 2857919.1)

Last updated on MARCH 25, 2022

Applies to:

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

Symptoms

ACTUAL BEHAVIOR


While trying to evaluate Open Enrollment from Batch Process>Evaluate Scheduled Event Participation> choose Life event Open, Program,  the following error is seen:

ERROR

 ORA-06502: PL/SQL: numeric or value error: NULL index table key value

 

We will take the example of the following scenario where 2022 Scheduled dates for Open  events are:

 Enrollment Period Start Date  1st October 2021
 Enrollment Period End Date  31st Dec 2021
 Assigned Life Event Date  1st Jan 2022

User has added a New Option A to plan hierarchy B with Effective Start date 01.01.2022 .

 

STEPS
The issue can be reproduced at will with the following steps:
1. Benefits Administration
2. Evaluation and Reporting>Processes
3. Life Event Processes>Evaluate Scheduled Event Participation
4. Submit

Changes

This error occurs if there is a change in program  or plan design  setup with incorrect effective start dates of new benefits objects added.

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
Changes
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.