Chapter 2: Introduction to Fast Formulas

What are Fast Formulas in Oracle Fusion?

Fast Formulas are powerful tools inside Oracle Fusion Applications (especially in HCM, Payroll, Benefits, Absence Management).
They allow you to define custom business rules without needing hardcore programming.

A Fast Formula is like a small script or logic block written in a simple language that Oracle Fusion can understand and execute automatically.

Where Are Fast Formulas Used?

Payroll: To calculate earnings, deductions, taxes.
Absence Management: To calculate leave balances or validate leave entries.
Benefits: To determine eligibility, coverage levels.
Time and Labor: To calculate worked hours and exceptions.
Compensation: To customize compensation plans.

Why Use Fast Formulas?

Customization without touching Oracle’s core code.
Flexibility to handle different business needs.
Automation of complex calculations.
Validation of user input during transactions.
Dynamic Processing based on data conditions.

Structure of a Fast Formula

A typical Fast Formula consists of:

Part	Description
Inputs	Variables that receive external data.
Declarations	Variables/constants declared for use inside the formula.
Logic	The calculation or validation rules written using simple expressions.
Return	The result that is passed back to the system.

Example: Simple Bonus Formula

INPUTS ARE salary
bonus = salary * 0.10
RETURN bonus

Explanation:

Takes salary as input.
Calculates 10% bonus.
Returns the bonus value.

Types of Fast Formulas

Type	Purpose
Payroll Calculation	Calculate pay elements.
Absence Accrual/Validation	Manage and validate leave.
Benefits Eligibility	Decide employee benefit eligibility.
Compensation	Calculate compensation elements.
Time and Labor	Process worked time rules.

Key Features of Fast Formulas

Easy to write — even non-programmers can learn.
Supports IF, ELSE, LOOP like normal coding.
Can use Database Items (DBIs) to fetch live data.
Can use User Defined Tables (UDTs) for lookup.
Supports Function Calls (built-in or custom).
Test and Debugging available through Formula Result logs.

Tips for Beginners

Always define INPUTS clearly.
Write comments inside your formulas for clarity.
Test small parts before full deployment.
Understand context (where the formula is attached — Payroll? Absence?).
Start simple and then move to advanced logic.

✍️ Mini Practice Quiz

1. What is the purpose of the RETURN statement in a Fast Formula?
(A) To call a database.
(B) To exit the formula execution.
(C) To pass back a calculated result.
(D) To delete the data.

Answer: (C) To pass back a calculated result.

2. Which Oracle Fusion module is most associated with Payroll Calculations?
(A) Supply Chain Management
(B) Human Capital Management (HCM)
(C) Customer Experience
(D) Finance Cloud

Answer: (B) Human Capital Management (HCM)

Fusion Katta

Pages

Oracle Fast Formulas - Chapter 2: Introduction to Fast Formulas