Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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
Get Started with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Enrollment Certification Fast Formula Issue

edited Oct 20, 2020 7:30PM in Benefits 7 comments

Summary

Suspend enrollment if the employee elects a lower number than previous election.

Content

I have written the following FF that evaluates correctly when I run it under enrollment results, but when I attach to the plan option certification as required, it runs the formula when the life event is evaluated and not when the person submits the enrollment.  Any way to change this?

 

 

 

Code Snippet

/*
**********************************************************************
FORMULA NAME: AB_BEN_CERT_HSA_SUSPENSION
FORMULA TYPE: Enrollment Certification Required
DESCRIPTION:  
Change History:
Name                 Date        Comments
---------------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------------------------
**********************************************************************
*/
DEFAULT FOR BEN_PTP_NAME is 'Health Savings Account'
DEFAULT FOR BEN_PLN_NAME IS 'Health Savings Account'
DEFAULT FOR BEN_OPT_NAME IS 'DEFAULT_OPTION_NAME'
DEFAULT_DATA_VALUE FOR BEN_EPE_ELIG_PER_ELCTBL_CHC_ID_NN IS -1
DEFAULT_DATA_VALUE FOR BEN_EPE_ENRT_CVG_STRT_DT_DN IS '1951/01/01 0:00:00'(date)
DEFAULT_DATA_VALUE FOR BEN_EPE_PL_NAME_TN IS 'X'
DEFAULT_DATA_VALUE FOR BEN_EPE_OPT_NAME_TN IS 'X'
DEFAULT FOR BEN_LER_NAME IS 'DEFAULT LER NAME'


L_PLAN_NAME   = BEN_PLN_NAME
L_OPTION_NAME = BEN_OPT_NAME
l_ler_name = BEN_LER_NAME
L_SUSPND_VOL_EMPL_LF = 'N'
l_pre_bnft_amt_number = 0
l_bnft_amt_number = 0
L_TRIG_CERT = ' '
L_PRE_OPTION = ' '
L_EFF_DATE = GET_CONTEXT(EFFECTIVE_DATE,TO_DATE('01/01/1951','DD/MM/YYYY'))


/*==================== Logic - Check Existing

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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