Results for “ff_formulas_f”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FF_FORMULAS_F is the core definition table for Oracle FastFormula (product code FF) in Oracle EBS 12.1.1 and 12.2.2. Owned by the HR schema, it stores the header records and source text of every FastFormula written against the Oracle FastFormula engine. FastFormula is the rules language used across Oracle HRMS, Payroll, Benefits, Compensation, OTL, and Advanced Pricing to drive calculations, eligibility checks, and derivations. Each row in FF_FORMULAS_F represents one formula definition for a given effective date range, business group, and legislation context.

The table is date-tracked using EFFECTIVE_START_DATE and EFFECTIVE_END_DATE, allowing multiple historical versions of the same formula to coexist. This is fundamental to payroll and benefits processing, where the formula applicable on a given pay period must reflect the rules in force at that time. Under a Data Vault modeling heuristic mined from the foreign key structure, FF_FORMULAS_F leans toward a satellite classification: it carries descriptive and text attributes (name, description, formula text, flags) around the formula identity anchored by its surrogate PK and business keys.

Key Information Stored

The 17 documented columns decompose into identity, business keys, descriptive attributes, and audit fields:

  • FORMULA_ID — surrogate primary key component; a system-generated unique identifier for the formula.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-effective range; part of the primary key and essential to versioned lookups.
  • FORMULA_NAME — the user-facing formula name; a business key candidate (FF_FORMULAS_F_UK2).
  • FORMULA_TYPE_ID — foreign key to FF_FORMULA_TYPES; classifies the formula (e.g., Oracle Payroll, QuickPaint, HR).
  • BUSINESS_GROUP_ID — owning business group; part of the unique business key.
  • LEGISLATION_CODE — country/legislation context; part of the unique business key.
  • DESCRIPTION — free-text explanation of the formula's purpose.
  • FORMULA_TEXT — the actual FastFormula source code; the largest and most significant payload column.
  • STICKY_FLAG — controls whether the formula context retains prior values across calls.
  • COMPILE_FLAG — indicates compilation state/behavior of the formula.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.
  • ZD_EDITION_NAME — editioning column supporting Online Patching (12.2.x) / EBR editioning.

The primary key FF_FORMULAS_F_PK is (FORMULA_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE) — extended with ZD_EDITION_NAME in 12.2.2. The unique index FF_FORMULAS_F_UK2 enforces uniqueness on (FORMULA_NAME, FORMULA_TYPE_ID, BUSINESS_GROUP_ID, LEGISLATION_CODE, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, ZD_EDITION_NAME), making these the true business-key candidate columns.

Common Use Cases and Queries

Typical scenarios include retrieving the source text of a formula for review, auditing which formulas exist for a legislation, and extracting formula logic for migration or documentation. A common query pattern filters on date-effectiveness and business context:

  • Fetch current formula text: SELECT formula_name, formula_text FROM ff_formulas_f WHERE formula_id = :id AND TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date.
  • List formulas by type and legislation: join FF_FORMULA_TYPES and filter on FORMULA_TYPE_ID and LEGISLATION_CODE.
  • Identify modified formulas: order by LAST_UPDATE_DATE for change auditing.
  • Detect duplicate or conflicting definitions across business groups using FORMULA_NAME.
  • Reporting on COMPILE_FLAG and STICKY_FLAG to troubleshoot compilation or context issues.

Because formula text is CLOB/long-form, queries should avoid selecting FORMULA_TEXT unless required, and should always restrict by effective dates to avoid returning multiple versions.

Related Objects

Together these objects form the FastFormula metadata model, with FF_FORMULAS_F serving as the authoritative store of formula identity, versioning, and source text.