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.

Coverage Amount Formula to pick up element entry values

Aug 6, 2024 2:35PM in Benefits 1 comment

Summary:

The coverage amount for the Life Insurance needs to be Total Cost of Employment so I have written a formula to pick up the values of the Element Entry values based on an example I found in customer connect - this is not working, please could someone post a formula that does work

This is the example formula:

3. How to use element entry values within benefits rates /********************************************************************** FORMULA NAME: RT_VALUE_CALC FORMULA TYPE: Rate Value Calculation ***********************************************************************/ Default_data_value for ORCL_PP_ELEMENT_2_AMOUNT_ENTRY_VALUE is 0 Default for BEN_OPT_NAME is 'NA' /* Initialization section */ i=1 l_val=0 l_ret=0 if (ORCL_PP_ELEMENT_2_AMOUNT_ENTRY_VALUE.exists(i)) then (l_val=ORCL_PP_ELEMENT_2_AMOUNT_ENTRY_VALUE[i]) if (BEN_OPT_NAME='ACT_ZHRX_PLAN_1_EMP') then ( l_ret=750-l_val ) else if (BEN_OPT_NAME='ACT_ZHRX_PLAN_1_FAM' OR BEN_OPT_NAME='ACT_ZHRX_PLAN_1_CHILD') then ( l_ret=1500-l_val ) if (l_ret

Tagged:

Howdy, Stranger!

To view full details, sign in.

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