Introduction to Fast Formula

Oracle Fast Formula is a simple way to write formulas using English words and basic mathematical functions. It enables users to pull information from the Oracle Fusion HCM database without needing to learn the database structure or a programming language. In essence, a fast formula is a generic expression for a calculation or comparison that can be reused with different input values.

Uses of Fast Formula

Payroll

Fast Formulas calculate payroll amounts, control the repetition of payroll flows, and determine when specific elements are processed during a payroll run. They also define groups of employees for processing, data entry, or reporting, validate element entries, and configure payment‑method preferences such as limiting the number and types of payment methods.

Benefit Administration

In benefits, fast formulas structure benefit plans, perform date calculations for enrollment and coverage periods, compute rate and coverage amounts, and enforce minimum, maximum, or upper/lower limits. They handle certification requirements, partial‑month and proration calculations, and evaluate eligibility and participation when standard eligibility criteria are insufficient.

Compensation Configuration

Compensation fast formulas set start and end dates for compensation allocations, determine person selection and hierarchy, and establish column defaults and currency selections for workforce compensation plans. They also define the source of items displayed in total compensation statements.

Time and Labor

For time and labor, fast formulas apply logic to process or calculate time, use parameters to pass values into the formula, and return results through output variables that feed back into the rule engine.

Components of Fast Formula

• Assignment Statement – Sets a value for a local variable, for example WAGES = HOURS_WORK * HOURLY_RATE.
• Return Statement – Returns values from a fast formula, such as passing the calculated wage back to the payroll run.
• Variable Types
• Input Variable – Appears in input statements and brings values into the formula (e.g., HOURS_WORK).
• Output Variable – Appears in return statements and sends values out of the formula.
• Local Variable – Used only within a single formula, often to hold intermediate results.
• Input Statement – Passes element input values to the fast formula during processing.
• Expression – A function or calculation that combines constants and variables with operators (+, -, *, /) to produce a value.
• Condition – Determines whether an expression is processed based on a true/false test (e.g., AGE < 20).
• Comment – Provides explanatory text or temporarily disables lines; comments are delimited by specific signs and should include the title, purpose, input descriptions, variable lists, and calculation explanations.

Example of Fast Formula

A common example calculates wages:

WAGES = HOURS_WORK * HOURLY_RATE

In this formula, WAGES is a local variable assigned the result of the expression HOURS_WORK * HOURLY_RATE. HOURS_WORK is an input variable that brings the number of hours worked into the formula, while HOURLY_RATE is part of the same expression. The assignment statement stores the result in WAGES, and the return statement passes WAGES back to the payroll run.

A conditional example illustrates how a condition controls processing:

IF AGE < 20 THEN
   TRAINING_ALLOWANCE = 30
END IF

If the condition AGE < 20 evaluates to true, the assignment TRAINING_ALLOWANCE = 30 is executed; otherwise, it is ignored. Comments can be added before the formula to describe its purpose, inputs, and logic, and they can also be used to comment out lines during testing.

Application Navigation

To create or edit a fast formula, navigate to Setup and Maintenance within the Fusion HCM user interface. From there, locate the Fast Formula task, select the appropriate module (Payroll, Benefits, Compensation, or Time & Labor), and use the provided editor to define assignment statements, input statements, expressions, conditions, and return statements. The interface also allows testing of formulas with sample inputs to verify correct behavior before deployment.