Dependent Coverage End Date Is Not Working Based On CON_DATE_OF_BIRTH Database Item

(Doc ID 2342392.1)

Last updated on JANUARY 02, 2018

Applies to:

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

Goal

To provide coverage to dependents to end of the month when they aged out during maintain eligible process.

 

The following fast formula was written based on CON_DATE_OF_BIRTH and it is not returns the contacts date of birth and it is always defaulted.

Default For CON_DATE_OF_BIRTH Is '1900/01/01 00:00:00' (Date)
Default For SESSION_DATE Is '1900/01/01 00:00:00' (Date)

if CON_DATE_OF_BIRTH(DATE) was defaulted then
(
l_end_dt = to_date('30-JAN-2017') --- Always defaulted and not going to else Condition
)
ELSE
if not CON_DATE_OF_BIRTH(DATE) was defaulted then
(
  l_dob = CON_DATE_OF_BIRTH
  l_session_date=SESSION_DATE
  l_age_out = TRUNC(MONTHS_BETWEEN(l_session_date,l_dob)/12)
  IF l_age_out>=26 THEN
  (
  l_end_dt = LAST_DAY(l_session_date)
  )
)

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