Benefits Extract Custom Data Rule Issue - No Data
SummaryThe Value is always 0 and No of records in Extract are decreases
The seeded Benefit Extract for FSA data is not fetching the Coverage amount, SO I have written a Fast formula to get the amount. But when the extract is run the Value is always 0 and no of the records fetched is decreased. Not all records are coming. I have attached the formula, could anyone review and let me know what is the issue is.
DEFAULT FOR BEN_PRV_ANN_RT_VAL IS -1 L_DEFAULT_DATE = TO_DATE('1951/01/01', 'YYYY/MM/DD') L_PERSON_ID = TO_TEXT(GET_CONTEXT(PERSON_ID, 0)) /*EFFECTIVE_DATE,HR_ASSIGNMENT_ID,BUSINESS_GROUP_ID,LER_ID,OPT_ID,ACTY_BASE_RT_ID,PL_ID,BENEFIT_RELATION_ID*/ L_BUSINESS_GROUP_ID = GET_CONTEXT(BUSINESS_GROUP_ID,1) L_HR_ASSIGNMENT_ID = GET_CONTEXT(HR_ASSIGNMENT_ID,1) L_PL_ID = GET_CONTEXT(PL_ID,1) L_LER_ID = GET_CONTEXT(LER_ID,1) L_OPT_ID = GET_CONTEXT(OPT_ID,1) L_BENEFIT_RELATION_ID = GET_CONTEXT(BENEFIT_RELATION_ID,1) L_ACTY_BASE_RT_ID = GET_CONTEXT(ACTY_BASE_RT_ID,1) L_EFF_DATE = GET_CONTEXT(EFFECTIVE_DATE, TO_DATE('1951/01/01 00:00:00')) CHANGE_CONTEXTS(HR_ASSIGNMENT_ID = L_HR_ASSIGNMENT_ID,PL_ID = L_PL_ID,OPT_ID = L_OPT_ID,BENEFIT_RELATION_ID=L_BENEFIT_RELATION_ID,ACTY_BASE_RT_ID=L_ACTY_BASE_RT_ID,EFFECTIVE_DATE =L_EFF_DATE,BUSINESS_GROUP_ID=L_BUSINESS_GROUP_ID,LER_ID=L_LER_ID ) ( L_BEN_AMT = BEN_PRV_ANN_RT_VAL ) RETURN L_BEN_AMT