Search Results ff_formulas_f




Overview
Explore in AI Chat

Overview

The FF_FORMULAS_F table is the central repository for FastFormula definitions within Oracle E-Business Suite (EBS) Human Resources (HR). FastFormula is a declarative language engine used to define complex business rules, calculations, and validations across various HR, Payroll, and Compensation modules. This table stores the core metadata and the actual formula text for every formula defined in the system. Its role is critical for the configuration and execution of payroll calculations, element processing, eligibility rules, and other rule-based processes. The table is date-effective, as indicated by the '_F' suffix and the EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns, allowing formulas to be versioned and updated over time to reflect legislative or business changes.

Key Information Stored

The table's structure is designed to uniquely identify and version formula definitions. The primary key (FF_FORMULAS_F_PK) is a composite of FORMULA_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. The FORMULA_ID is the system-generated unique identifier. A separate unique key (FF_FORMULAS_F_UK2) enforces business-level uniqueness based on a combination of FORMULA_NAME, FORMULA_TYPE_ID, BUSINESS_GROUP_ID, LEGISLATION_CODE, and the effective date columns. This ensures that within a specific business group and legislative context, a formula name and type combination is unique across its effective lifetime. Other essential columns include FORMULA_TEXT, which holds the actual FastFormula code, and FORMULA_TYPE_ID, which categorizes the formula (e.g., for a payroll rule, an element input validation, or a benefits calculation).

Common Use Cases and Queries

A primary use case is auditing and analyzing formula configurations, especially during upgrades, legislative updates, or troubleshooting calculation errors. Developers and functional consultants frequently query this table to review formula logic. A common pattern is to retrieve the current active version of a specific formula for a business group. For example: SELECT formula_text FROM ff_formulas_f WHERE formula_name = 'MY_PAYROLL_RULE' AND business_group_id = 123 AND SYSDATE BETWEEN effective_start_date AND effective_end_date;. Another typical query involves listing all formulas of a certain type within a legislation code for impact analysis: SELECT formula_name, effective_start_date FROM ff_formulas_f WHERE formula_type_id = (SELECT formula_type_id FROM ff_formula_types WHERE formula_type_name = 'QuickPaint') AND legislation_code = 'US' ORDER BY formula_name;. Reporting often joins this table with FF_FORMULA_TYPES to provide descriptive type names.

Related Objects

The FF_FORMULAS_F table has a direct and essential relationship with the FF_FORMULA_TYPES table, which defines the categories of formulas. This relationship is enforced by the foreign key where FF_FORMULAS_F.FORMULA_TYPE_ID references FF_FORMULA_TYPES. This join is fundamental for any query that needs to filter or report on formulas by their functional type (e.g., "Payroll Rule," "Element Eligibility"). While the provided metadata lists only this specific foreign key, in practice, the FORMULA_ID from this table is referenced by numerous other FastFormula-related tables and application programming interfaces (APIs) that store formula execution contexts, usages, and compiled versions. The table is a parent to the formula definitions used throughout the HRMS product family.