Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
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
1
Views
1
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!