My Oracle Support Banner

Dependent Coverage End Date is not Working Based on CON_DATE_OF_BIRTH Database Item (Doc ID 2342392.1)

Last updated on AUGUST 24, 2020

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 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
if not CON_DATE_OF_BIRTH(DATE) was defaulted then
  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



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

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