Results for “ff_formula_types”

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

Overview

FF_FORMULA_TYPES is an Oracle HR schema table within the FastFormula (FF) product family, available in Oracle E-Business Suite 12.1.1 and 12.2.2. It serves as the classification mechanism for organizing FastFormula definitions into logical groups that can be associated with specific formula contexts. Rather than treating every formula as an isolated artifact, the table provides a controlled vocabulary that ties formulas to the business processes and product modules they serve, such as payroll calculations, benefits eligibility, accrual plans, and compensation workbench processing.

From a Data Vault modeling perspective, the metadata classifies this object as hub-leaning. This is a reasonable heuristic suggestion: FORMULA_TYPE_ID acts as a stable, unique business key that is referenced by numerous downstream tables, while the descriptive attributes (name, description) and audit columns function in a satellite-like capacity. The table thus behaves as a central reference hub from which considerable transactional and definitional detail radiates outward through foreign key relationships.

Key Information Stored

The documented schema for 12.2.2 contains nine columns. The most significant are listed below:

• FORMULA_TYPE_ID — The surrogate primary key, defined by the FF_FORMULA_TYPES_PK constraint. It uniquely identifies each formula type and is the column most frequently propagated as a foreign key into dependent tables.
• FORMULA_TYPE_NAME — The business-key candidate, enforced by the FF_FORMULA_TYPES_UK2 unique index. It carries the human-readable classification label used throughout the application, such as a payroll formula type or a benefits formula type.
• TYPE_DESCRIPTION — Free-text description clarifying the intended purpose or scope of the formula type.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle audit columns recording who last modified the row and when.
• CREATED_BY, CREATION_DATE — Standard creation audit columns identifying the original author and timestamp.
• ZD_EDITION_NAME — The editioning column that supports Oracle EBS 12.2 online patching. Both unique indexes include this column, meaning the true uniqueness of FORMULA_TYPE_ID and FORMULA_TYPE_NAME is scoped to an edition. Queries against this table in a 12.2.2 environment should generally filter or join on ZD_EDITION_NAME to avoid returning rows from inactive editions.

Common Use Cases and Queries

Typical usage centers on resolving formula type identifiers to readable names for reporting, and on tracing which formulas belong to a given context. A common reporting query joins the type table to the formula definitions:

SELECT ft.formula_type_name, f.formula_name
FROM hr.ff_formula_types ft, hr.ff_formulas_f f
WHERE ft.formula_type_id = f.formula_type_id
AND ft.zd_edition_name = 'SET1';

Analysts also enumerate the available classification values when diagnosing why a formula does not appear in a given context, or when validating configuration migrated between environments. A simple lookup pattern is:

SELECT formula_type_id, formula_type_name, type_description
FROM hr.ff_formula_types
WHERE zd_edition_name = 'SET1'
ORDER BY formula_type_name;

Because the table is small and slowly changing, it is well suited to extraction into a reference or dimension table within a data warehouse, serving as a conformed lookup for formula-related facts.

Related Objects

The following objects reference FF_FORMULA_TYPES through documented foreign keys:

• FF_FORMULAS_F — joins on FF_FORMULAS_F.FORMULA_TYPE_ID; the primary bridge between types and actual formula definitions.
• FF_FORMULA_TYPE_COMPONENTS — joins on FORMULA_TYPE_ID; defines the component structure associated with each type.
• FF_FTYPE_CONTEXT_USAGES — joins on FORMULA_TYPE_ID; maps formula types to the contexts in which they are valid.
• FF_QP_REPORTS — joins on FORMULA_TYPE_ID; links types to QuickPay report definitions.
• HR_S_FORMULAS_F and HR_S_FORMULA_TYPES — the seeded, system-owned counterparts used by Oracle-delivered formula configurations.
• HR_S_QP_REPORTS and HR_S_FTYPE_CONTEXT_USAGES — seeded counterparts for QuickPay reporting and context usage, respectively.

Collectively these relationships confirm the table's role as a foundational reference object within the FastFormula subsystem.