Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Post Election Edit Formula Issue — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Post Election Edit Formula Issue

Received Response
10
Views
5
Comments
edited Aug 23, 2021 5:43PM in Benefits 5 comments

Summary

Post Election Edit Formula Not going to the loop

Content

Hi All,

We have requirement Employee should not select Parent or spouse plan without selecting the Employee Plan.

I have created below formula found it was not going in to the loop.It is only reading default statement.Please help me what is wrong with below formula.

 

Thanks,

Sandeep

Code Snippet

DEFAULT FOR BEN_PIL_LF_EVT_OCRD_DT IS '1951/01/01 00:00:00'(date)
default for l_enrld is 'Y'
default for l_dpnt_enrld1 is 'Y'
default for l_dpnt_enrld2 is 'Y'
SUCCESSFUL = 'Y'
ERROR_MESSAGE=' '
CHANGE_CONTEXTS(EFFECTIVE_DATE = BEN_PIL_LF_EVT_OCRD_DT )
l_enrld = ben_fn_get_char_value(
'BEN_PRTT_ENRT_RSLT'
,'ENROLLED'
,'Benevolent Fund Employee 200K'
,'Covered')

l_dpnt_enrld1 = ben_fn_get_char_value(
'BEN_PRTT_ENRT_RSLT'
,'ENROLLED'
,'Benevolent Parents 90K'
,'Covered'
)
l_dpnt_enrld2 = ben_fn_get_char_value(
'BEN_PRTT_ENRT_RSLT'
,'ENROLLED'
,'Benevolent Spouse and Children 1200K'
,'Covered'
)
If ( l_dpnt_enrld1='N' and l_dpnt_enrld2='N' ) and (l_enrld = 'Y') then (SUCCESSFUL='N'
ERROR_MESSAGE = 'You should enrol Benevolent Fund Employee 200k to enrol Benevolent Parents or Benevolent Spouse and Children 1200K ')
return SUCCESSFUL,ERROR_MESSAGE

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!