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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms