Fast Formula Functions in Oracle Fusion HCM

In Oracle Fusion HCM, Fast Formula is a powerful tool that allows you to create complex calculations and rules for various HR processes. Fast Formulas are written in a proprietary domain-specific language designed for HR calculations. They are used in various areas of Oracle Fusion HCM, including payroll, benefits, absence management, compensation, and more.

Fast Formula functions are pre-built routines that you can use within your Fast Formula calculations to perform specific tasks or operations. These functions help simplify and streamline the formula development process, as you don’t have to write the entire logic from scratch.

Here are some common categories of Fast Formula functions in Oracle Fusion HCM:

• General Functions:
  • ABS – Returns the absolute value of a number.
  • ROUND – Rounds a number to the nearest integer or to a specified decimal place.
  • TRUNC – Truncates a number to a specified number of decimal places.
  • MAX – Returns the maximum value from a list of values.
  • MIN – Returns the minimum value from a list of values.
• Date Functions:
  • ADD_MONTHS – Adds a specified number of months to a given date.
  • LAST_DAY – Returns the last day of the month for a given date.
  • MONTHS_BETWEEN – Calculates the number of months between two dates.
  • SYSDATE – Returns the current system date.
• Payroll Functions:
  • PAY_VALUE – Retrieves a payroll element’s value for an employee.
  • PAY_INPUT_VALUE – Retrieves a payroll input value for an employee.
  • PAY_COST_ALLOCATION – Calculates the cost allocation for a specific payroll element.
• Absence Functions:
  • ABSENCE_DAYS – Calculates the number of days between two dates, considering the absence calendar.
  • GET_ABS_BALANCE – Retrieves the available absence balance for an employee.
• User-Defined Functions:
  • You can also create your own custom functions using Fast Formula to meet specific business requirements.

Each function has its own syntax and usage, and you can use these functions within your Fast Formulas to perform calculations and logic based on your business needs.

To use Fast Formula functions, you typically write a formula definition using the Fast Formula Editor, and then you can call the functions within the formula’s logic. The Fast Formula engine will execute the formula during payroll or other HR processes, and the result will be used for the intended purpose, such as calculating an employee’s pay, absence entitlement, etc.