Oracle Fast Formulas - Chapter 36: Using Fast Formula in Absence Management

 

Overview:

Fast Formulas play a crucial role in Absence Management within Oracle Fusion HCM. They allow you to customize and control eligibility, accruals, validation, and entitlements based on specific business rules.

Types of Formulas Used in Absence Management:

  1. Accrual Matrix Formula – Used to determine leave earned based on length of service.

  2. Participation Eligibility Formula – Determines whether the employee is eligible for a particular absence plan.

  3. Accrual Formula – Calculates the exact accrual rate.

  4. Entitlement Formula – Defines leave available at any point in time.

  5. Duration Formula – Overrides default leave duration calculation.

  6. Validation Formula – Validates leave entry based on rules like blackout periods or overlapping.

Example: Accrual Formula for Annual Leave

 
DEFAULT FOR SALARY IS 0
DEFAULT FOR YEARS_OF_SERVICE IS 0

INPUTS ARE SALARY, YEARS_OF_SERVICE

IF YEARS_OF_SERVICE < 5 THEN
  RETURN 12
ELSE
  RETURN 15

This formula grants 12 days leave per year for service less than 5 years, and 15 days otherwise.

Tips:

  • Use context values like ABSENCE_TYPE, LEAVE_REASON effectively.

  • Always test formulas in a sandbox before deploying to production.

  • Combine formulas with eligibility profiles for flexible configurations.

Common Use Cases:

  • Pro-rata leave for new joiners.

  • Carry forward limits based on grade.

  • Blackout periods during peak business time.

Quick Quiz:

  1. Which formula type is used to validate whether an absence request is allowed?

  2. What context value can be used to identify the absence type in formulas?

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)