Need to fetch prior balances for 401k in Fast Formulas for annual limit check
The 401K deduction amount is getting reset for each assignment in current year; which may lead to over deduction than the 401K annual limit. We are trying to fetch the balance of the Prior assignments ended in the current year using DBIs - ORA_HRX_US_PRIOR_DEFERRED_COMPENSATION_401K_REL_NOCB_YTD but getting value a 0; so that we can sum up to calculate the total balance(401K deduction)
We tried executing the delivered FF - US_PRETAX_401K_ANNUAL_LIMIT_CHECK; even with this the value is 0.
Also, have tried to access ORA_HRX_US_TOTAL_DEFERRED_COMPENSATION_401K_REL_NOCB_YTD so that the formula gets the amount/balance(401k deduction) for older assignment and the current assignment. But no luck.