Oracle Fusion HCM Extracts : Chapter 4: Using Fast Formulas in Extracts

 

Chapter 4: Using Fast Formulas in Extracts

🔷 Objective

Learn how to use Fast Formulas in HCM Extracts to customize data logic dynamically.

🔷 What is a Fast Formula?

Fast Formulas are a powerful feature in Oracle HCM used to perform calculations, validations, and derive data. In extracts, they help manipulate data for attributes that require conditional logic or derived values.

🔷 Use Cases of Fast Formulas in Extracts

• Formatting full name from first and last names

• Conditional display of sensitive data

• Calculating tenure, age, etc.

🔷 Types of Formulas in Extracts

• Extract Rule Formula – Filter data at record or group level

• Extract Attribute Formula – Calculate or derive attribute value

• Extract Trigger Formula – Condition to start an extract

🛠️ How to Create a Fast Formula

1. Navigate to: Navigator → My Client Groups → Payroll → Fast Formulas

2. Click on Create → Provide Name, Type (Extract Rule / Attribute)

3. Write logic using Oracle’s formula syntax

4. Validate and save

📌 Example Formula: Calculate Full Name

DEFAULT FOR FIRST_NAME IS ' '
DEFAULT FOR LAST_NAME IS ' '
RETURN FIRST_NAME || ' ' || LAST_NAME

Assign this to the attribute "Full Name" in your extract.

💡 Tips:

• Always validate formula before saving

• Use formula result rules to debug

• Use database items wisely for performance

🏁 Conclusion

Fast Formulas enhance the dynamic capability of HCM Extracts, allowing tailored outputs per requirement. In the next chapter, we'll explore advanced filtering and criteria for data selection.

🔹 Next Steps

• Previous Chapter:  Chapter 3: Creating Your First HCM Extract

• Next Chapter: Chapter 5: Advanced Filtering and Criteria in Extracts