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 22.214.171.124.0 and later
Information in this document applies to any platform.
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',
'Voluntary Term Life - new',
l_amt_text = l_amt (text)
if (l_amt_text = 'N')then
(l_cvg = 0)
(l_cvg = to_number(l_amt))
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?
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