Results for “hr_s_formulas_f”

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

Overview

HR_S_FORMULAS_F is a core Human Resources (PER) table in Oracle EBS 12.1.1 and 12.2.2 that stores the definition of Oracle Fast Formula text. The "_F" suffix indicates this is a date-tracked ("F" = effective-dated) table, carrying EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns that allow multiple versions of the same formula to coexist over time. Fast Formulas are the Oracle Applications rule engine: instead of hard-coding business logic, Oracle delivers and customers author formulas written in a dedicated syntax that are compiled and executed at runtime for payroll calculations, benefits eligibility, accruals, absence, and compensation. This table is the persistent home for that source text.

Per the supplied ETRM metadata, the object owner is HR, the status is VALID, and it is documented as "Retrofitted." The heuristic Data Vault classification mined from the FK structure is standalone. In modeling terms this suggests the table behaves as a self-contained hub-like reference of formula definitions, without the dense link relationships that characterize transaction tables. A single foreign key is documented: FORMULA_TYPE_ID references FF_FORMULA_TYPES, anchoring each row to a formula category. The documented physical schema for 12.2.2 lists 16 columns.

Key Information Stored

• FORMULA_ID — the surrogate primary key that uniquely identifies a formula row.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date-tracked validity window of a formula version; together they define which version is active on any given date.
• BUSINESS_GROUP_ID — the operating unit / business group that owns the row, supporting multi-tenant isolation.
• LEGISLATION_CODE — the country legislation to which the formula applies, driving statutory localization.
• FORMULA_TYPE_ID — the foreign key to FF_FORMULA_TYPES, categorizing the formula (for example Payroll, Accrual, Benefits).
• FORMULA_NAME — the business-facing identifier used in calls and in the Formulas form.
• DESCRIPTION — free-text documentation of the formula's purpose.
• STICKY_FLAG — controls whether the formula is locked against automatic regeneration by Oracle seed data.
• COMPILE_FLAG — indicates compile state / whether the formula requires (re)compilation.
• FORMULA_TEXT — the actual Fast Formula source code body.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE.

A unique index is documented as SYS_IL0000044132C00016$$, an internal index artifact rather than a true named business-key constraint; candidate business keys should be treated as FORMULA_NAME combined with BUSINESS_GROUP_ID, LEGISLATION_CODE, and the effective dates.

Common Use Cases and Queries

Typical scenarios include auditing which formulas are active for a legislation, comparing versions across effective dates, and searching FORMULA_TEXT for hard-coded values. A representative pattern joins the formula to its type:

• SELECT f.FORMULA_NAME, f.FORMULA_TEXT, t.FORMULA_TYPE_NAME FROM HR.HR_S_FORMULAS_F f, FF_FORMULA_TYPES t WHERE f.FORMULA_TYPE_ID = t.FORMULA_TYPE_ID AND f.BUSINESS_GROUP_ID = :p_bg_id AND SYSDATE BETWEEN f.EFFECTIVE_START_DATE AND f.EFFECTIVE_END_DATE.
• Filter by LEGISLATION_CODE to list a country's statutory formulas.
• Query by FORMULA_NAME to retrieve the compiled source for troubleshooting.

Related Objects

• FF_FORMULAS_VL / FF_FORMULAS_TL — the multilingual views that expose formula definitions to the application layer.
• FF_FORMULA_TYPES — joined on FORMULA_TYPE_ID; classifies each formula.
• FF_FORMULA_TYPES_TL — translated type names.
• FF_COMPILED_FORMULAS — stores the compiled artifact produced from FORMULA_TEXT.
• FF_FUNCTIONS / FF_FORMULA_FUNCTIONS — register the callable functions a formula can invoke.
• FF_ROUTES / FF_ROUTE_CRITERIA — determine which formula is selected at runtime.
• PAY_FORMULA_RESULTS — consumes executed formula output in payroll.

The Fast Formula APIs (FF_EXECUTE / the formula compiler) read this table directly, making HR_S_FORMULAS_F the authoritative source of truth for rule logic across the PER and PAY modules.