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

Last updated on JUNE 08, 2022

Applies to:

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

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