Rate Periodization FF fetching incorrect value for DBI - BEN_PEN_ORGNL_ENRT_DT_DN during HDL load
I'm facing an issue in our Benefits Rate Periodization formula for Health Care & Dependent Care FSA during conversion.
Conversion life event is added on 10/31/2020 and evaluated with ‘Apply Defaults’ field as No.
Then the participant enrolment data file is loaded, passing the original enrolment date as 5/1/2020.
The rate periodization formula is being executed as the last sub-process during the HDL load.
The DBI ‘BEN_PEN_ORGNL_ENRT_DT_DN’ used in the formula is not fetching the 5/1/2020 date.
Instead its fetching 10/31/2020, which is resulting in incorrect calculation.
Please let me know if you’ve come across this before.
Edit: I've tried using the function ben_fn_get_char_value, changed contexts, used alternate single-row & multi-row DBIs of enrolment results, etc. but nothing worked.