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

Last updated on AUGUST 21, 2015

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.

Goal

On : 11.1.9.2.0 version, Fast Formula

End Enrollment FF not compiling although the DBI is correct

Getting error - Formula ARES 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
 

Solution

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