ENROLLMENT IN ONE OPTION SHOULD AUTOMATICALLY ENROLL TO SAME OPTION IN ANOTHER (Doc ID 2511372.1)

Last updated on JUNE 08, 2022

Applies to:

Goal

Trouble with fast formulas for HCM Benefits module - coverage amount calculation

I am trying to calculate a coverage amount for an employee benefit based on the amount selected for another benefit. The coverage amount for Voluntary Life insurance is user-defined, and the coverage amount for AD&D insurance should be equal to this user-defined amount and should update automatically if the user selects a new value for coverage. The fast formula that I used is:

l_eff_date = get_context(effective_date, to_date('1900/01/01 00:00:00'))
l_new_date = add_days(l_eff_date, 31)
change_contexts(effective_date = l_new_date)
l_amt = ben_fn_get_char_value('BEN_PRTT_ENRT_RSLT',
'BNFT_AMT',
'Voluntary Term Life - new',
'Employee')
l_amt_text = l_amt (text)
if (l_amt_text = 'N')then
(l_cvg = 0)
else
(l_cvg = to_number(l_amt))
return l_cvg

First, I change context to the next month because the coverage for Voluntary Term Life does not start until a month later. Then, I get the Benefit Amount, check if it is N (i.e. not yet defined), and if it is defined then return the amount. In Evaluation and Reporting the correct amount is returned, and when I run it the coverage for AD&D is set to the default value for Voluntary Life ($10,000). However, if I change the Voluntary Life coverage, AD&D remains static. Is there any way to fix this problem?
 

Solution

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