My Oracle Support Banner

Receiving Error 'ORA-1858 occurred at line 60 of formula' During Open Enrollment (Doc ID 1400665.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Benefits - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to click the Next button from the Cover Dependents page in Self-Service, the following error occurs:

ERROR
-----------------------
Row 1 Error - ORA-1858 occurred at line 60 of formula BEN_DEP_CERT_REQ

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to responsibility Employee Self-Service and select the Benefits function.
2. Click the Update Benefits button and select newly eligible Medical Plan with Employee + Family Option.
3. Click the Next button and select existing dependents to be covered.
4. Click the Next button.
Error occurs.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot enroll in Benefits via Self Service.

Changes

Formula Details:

FORMULA NAME : BEN_DEP_CERT_REQ
FORMULA TYPE : Dependent Certification Required
DESCRIPTION : Formula to return a 'Y' for certification required or 'N' for certification not required.

/*================ FORMULA SECTION BEGIN =======================*/

l_cert_req = 'Y'

l_cert_req = BEN_DEP_CERT_REQ(SESSION_DATE, BEN_PIL_LF_EVT_OCRD_DT, CON_PERSON_ID)

return l_cert_req

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.