My Oracle Support Banner

Fusion Benefits: End Enrollment Fast Formula (FF) Not Compiling Although the DBI Is Correct (Doc ID 1987051.1)

Last updated on FEBRUARY 06, 2023

Applies to:

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

Symptoms

The following error is seen when trying to compile an End Enrollment Fast Formula:

Formula AXXXX COVERAGE END DATE1, line 5, a local variable was used before being initialized.


Default for BEN_PIL_LF_EVT_OCRD_DT is '01-jan-0001' (date)

l_end_dt = '01-jan-0001' (date)

IF (DATE_TO_TEXT(BEN_PIL_LF_EVT_OCRD_DT, 'DD') = '01')
  THEN l_end_dt = ADD_DAYS((BEN_PIL_LF_EVT_OCRD_DT), -1)
  ELSE l_end_dt = LAST_DAY(BEN_PIL_LF_EVT_OCRD_DT)

RETURN l_end_dt

Changes

 

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


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