Rounding issue with Compensation and Absence Elements — 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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Rounding issue with Compensation and Absence Elements

Due to a requirement from the state we're implementing Oracle in, we had to write a custom periodicity fast formula. This formula is attached to all of our elements in the system and is responsible for calculating pay based on "Total Salary/(Days of the year/14)" instead of the delivered "Total Salary/26" (26 pay periods in a year).

This is working as expected except for an issue we're running into with rounding.

Currently, when an employee takes a multi-day absence (8 hours a day), we end up having a day or two that is being paid at 0.01 higher than the others. This is the same issue for compensation elements that are paid on a week-to-week basis (one will be 0.01 higher than the other).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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