Human Capital Management - EBS (MOSC)

MOSC Banner

Fast Formula and Applications Utilities Lookups

edited Jul 4, 2019 5:41AM in Human Capital Management - EBS (MOSC) 2 commentsAnswered ✓
I have a table in App Utils lookups (FTE_HOURS_PER_WEEK). The Code is a numeric value relating to the employee FTE.  The Meaning is the number of hours worked in a week for that particular FTE.  eg code = 10 and meaning = 4.25 or code = 100 and meaning = 37.5

I want to write a fast formula which will take the employee FTE, look it up in the App Utils lookup table, and return the corresponding number of hours per week.  So if an employee is 100% FTE, I will receive a value of 37.5, or if the employee is on 10% FTE, I will recieve a value of 4.25.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center