Oracle Fast Formulas - Chapter 10: Formula Writing Syntax and Best Practices

 

Chapter 10: Formula Writing Syntax and Best Practices

---

Objective of This Chapter

This chapter explains the basic syntax rules of writing Fast Formulas and highlights best practices to make formulas efficient, readable, and easy to maintain.

---

Basic Syntax of Fast Formula

Syntax Element	Description
Variables	Used to store and manipulate data
IF-THEN-ELSE	Used for logical decision making
RETURN	Used to return result values
Comments	Explained by using ‘/** */’ block for clarity
Functions	Built-in or user-defined functions used for calculations

---

Common Syntax Structure

1. Declaring Variables
   Example:

    
   INPUTS ARE salary
   

2. Conditions with IF-THEN-ELSE
   Example:

    
   IF salary > 50000 THEN
     bonus = salary * 0.1
   ELSE
     bonus = salary * 0.05
   

3. Returning Values
   Example:

    
   RETURN bonus
   

4. Comments for Clarity
   Example:

    
   /* This formula calculates bonus based on salary slab */
   

---

Important Syntax Rules

• Every formula must have at least one RETURN.

• Oracle Fusion formulas are case-insensitive.

• Use clear variable names for better understanding.

• Use parentheses properly to avoid logical errors.

• Do not use reserved keywords like AND, OR as variable names.

---

Best Practices in Writing Formulas

Best Practice	Why it is Important
Keep formulas simple	Easier to debug and maintain
Use clear variable names	Helps others understand your logic
Add comments	Essential for team collaboration and future updates
Break complex logic	Divide into smaller, manageable sections
Test formulas individually	Helps catch errors early
Use Default Values wisely	Prevents null errors
Handle all possible scenarios	Improves formula reliability and reduces risk

---

Example: Good vs Bad Practice

Bad Practice:

 
sal = sa + bo * 0.1
RETURN sal

Good Practice:

 
/* Calculate salary with bonus */
salary = sa
bonus = bo * 0.1
total_salary = salary + bonus
RETURN total_salary

---

How to Make Formulas Reusable

• Use inputs wisely.

• Avoid hardcoding values like dates, salary amounts.

• Create common library functions wherever possible.

---

Mini Practice Quiz

1. Is it necessary to have a RETURN in every formula?
   Answer: Yes

2. Are Oracle Fusion formulas case-sensitive?
   Answer: No

3. What is the use of comments in formulas?
   Answer: They make formulas easier to understand and maintain.