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

HCM Extract| Fast Formula - Need help to divide Working Hours by 2080 in fast formula

edited Nov 20, 2020 5:32AM in HCM Integrations 3 comments

Summary

Fast Formula of type extract Rule to get the employee working hour divided by 2080

Content

Hello Everyone,

I am new to HCM extract and Fast Formulas. I need help on adding a new attribute under a HCM record.

As per new requirement, I need to add a new attribute named ‘Standard  Hours’ under a record named Emp_details_rec. What we want is to get the normal working hours for an employee (which I am able to get from per_all_assignment_m table) and divide its value by 2080 i.e. Normal Working Hour/ 2080. For example – Employee XYZ, normal or annual working hour is 2080, so Standard Hour = normal working hour/ 2080 which will be 1. I have created a Rule attribute as shown in attached picture.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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