My Oracle Support Banner

Need function for Post Election Edit Fast Formula to Find Whether a Dependent is Enrolled or Not (Doc ID 2531901.1)

Last updated on SEPTEMBER 18, 2020

Applies to:

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

Goal

On : 11.13.19.01.0 version, Fast Formula - Benefits
 
User is having a Post election edit Fast formula where the enrollment is allowed only if the employee follows a hierarchy in selecting the contacts.

To find whether a dependent is enrolled or not we use the below function
BEN_FN_GET_CHAR_VALUE('BEN_PRTT_ENRT_RSLT','ENROLLED',plan_name,option_name,DEPENDENT_FULL_NAME,full_name)

The function is returning wrong values.

Function used:
l_par_e = ben_fn_get_char_value('BEN_ELIG_CVRD_DPNT','ENROLLED','Waive Dependents','Waive Dependents','DEPENDENT_FULL_NAME','Baker, Father')

l_par_f = ben_fn_get_char_value('BEN_ELIG_CVRD_DPNT','ENROLLED','Health Insurance PH','NA','DEPENDENT_FULL_NAME','Baker, Father')

Expected Result:
l_par_e = N
l_par_f = Y

Actual Result:
l_par_e = Y
l_par_f = Y
 

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
References


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