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

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

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


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


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.


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