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 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.

Absence duration is correct but deduction from the balance is incorrect

edited Aug 25, 2020 8:35AM in Workforce Management 4 comments

Summary

Deducting extra days for weekoffs because of conversion formula but duration is calculated correctly

Content

UOM of absence  type/plan is Days but we need to include the off days (like saturday /sunday) also in the leave duration. So we added a conversion formula at type using simple FF 

days = DAYS_BETWEEN(IV_END_DATE,IV_START_DATE) +1

duration = round(days)

After adding conversion formula , the duration came correctly eg leave applied from Friday till Monday , the duration shows 4 days which initially was showing 2 days.

The issue is that, from the balance 6 days were deducted ie for weekoffs (saturday/sunday) it deducted 2days for a day so total 6(1+2+2+1).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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