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: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

OTL Formula working fine in Logs but not distributing the values in calculated time

Summary:

We have a requirement to distribute the hours based on certain conditions.

Condition 1:- If Regular Hours are more than 40 and less than 45 then it should be given as Overtime.

Condition 2:- If Regular Hours are more than 45 then it should be given as Excess Overtime.

I'm giving 3 inputs for the time rule. Time Category, Limit1 and Limit2. I'm deriving the calculation of the formula based on Limit1 and Limit2 which are 40 and 45, given in the time rule.

the formula works fine when I see the logs but it's not distributing the values into Overtime and Excess Overtime. Here's the foemula.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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