Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Need to fetch prior balances for 401k in Fast Formulas for annual limit check — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need to fetch prior balances for 401k in Fast Formulas for annual limit check

Received Response
2
Views
2
Comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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