My Oracle Support Banner

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

Last updated on SEPTEMBER 10, 2020

Applies to:

Oracle Fusion Benefits Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

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

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
Goal
Solution


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