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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Need to fetch prior balances for 401k in Fast Formulas for annual limit check
Hello everyone,
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.
0