Dependent Coverage End Date Is Not Working Based On CON_DATE_OF_BIRTH Database Item
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.
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 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
if not CON_DATE_OF_BIRTH(DATE) was defaulted then
l_dob = CON_DATE_OF_BIRTH
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)
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