Oracle Fast Formulas - Chapter 26: Oracle Fusion Fast Formulas – Formula Result Rules and Database Items

 

Chapter 26: Oracle Fusion Fast Formulas – Formula Result Rules and Database Items

In this chapter, we explore two critical components of Oracle Fusion Fast Formulas:

1. Formula Result Rules, which help control what your formula returns.

2. Database Items, which allow access to specific data from Fusion HCM modules.

---

🔹 What Are Formula Result Rules?

Formula result rules define how a fast formula should return values to the calling process. The result of a formula depends on its type. Each formula type expects a specific return value. For example, a Payroll formula might return a numeric value like a salary amount, while an Eligibility formula may return “Y” or “N”.

✔ Common Return Types:

Formula Type	Expected Result Type
Payroll Calculation	Numeric (e.g., earnings)
Eligibility	Character (Y/N)
Validation	Character (e.g., valid/invalid)
Compensation	Numeric or character

🔄 Example:

plsql
RETURN_VALUE = 1500

This sets the final output of the formula to 1500. RETURN_VALUE is a system keyword used for result output.

---

🔹 How to Define Results in Fast Formula?

You define return values in the “Return” section at the end of your formula. For most use cases, this involves assigning values to RETURN_VALUE or other expected output variables.

Example: Simple Calculation

plsql
INPUT1 = 100
INPUT2 = 200

TOTAL = INPUT1 + INPUT2

RETURN_VALUE = TOTAL

---

🔹 What Are Database Items?

Database Items (DBIs) are predefined values that Oracle Fusion exposes for use in Fast Formulas. These items allow you to pull information from the application without writing complex SQL.

Examples of DBIs:

DBI Name	Description
PER_ASG_JOB	Assignment job of the person
PER_ASG_ORGANIZATION_NAME	Organization name of the employee
PER_ASG_SALARY_AMOUNT	Salary amount from assignment
PER_PERSON_NAMES_F	Full name of the person

You can use these items directly in the formula if permitted by the formula type.

---

🔍 How to View Available Database Items?

Navigate in Oracle Fusion to:

Navigator → Payroll → Fast Formulas → View Database Items

You can search by:

• Formula type

• Module (e.g., Payroll, Benefits, Compensation)

---

📌 Using DBIs in Fast Formulas

Example: Return Person’s Job

plsql
JOB = PER_ASG_JOB

RETURN_VALUE = JOB

---

🛠️ Important Notes:

• Not all DBIs are available in every formula type.

• Use the “View Database Items” page to confirm if a DBI is supported.

• You can also pass Inputs to your formula instead of relying only on DBIs.

---

📝 Mini Quiz

1. What keyword is used to assign a return value in fast formulas?
a) OUTPUT
b) RETURN
c) RETURN_VALUE
d) FORMULA_RESULT

✅ Answer: c) RETURN_VALUE

2. What does PER_ASG_JOB return?
a) Employee ID
b) Salary Amount
c) Employee’s Job Name
d) Department Name

✅ Answer: c) Employee’s Job Name