Results for “ff_formulas_f_v”

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

Overview

FF_FORMULAS_F_V is an Oracle E-Business Suite view owned by the APPS schema and registered as VALID in both EBS 12.1.1 and 12.2.2. It belongs to the FF (FastFormula) product family and, according to the ETRM metadata, is documented as being "used to support user interface." This description places the view firmly in the presentation and lookup layer rather than the transactional core of FastFormula. It does not introduce new business data; instead, it joins the formula repository to its type definitions, its compilation status, and the current session context so that forms, self-service pages, and reporting queries can present a clean, user-facing row for each formula.

Because FastFormula is invoked throughout Oracle HRMS, Payroll, Benefits, OTL, and Advanced Compensation, the view acts as a controlled read surface over otherwise normalized, date-tracked formula data. Developers who search for ff_formulas_f_v are typically looking for an officially documented alternative to querying FF_FORMULAS_F directly, since the view resolves the formula type into a translatable display value and annotates whether a formula has been verified.

Underlying Base Objects

The ETRM metadata records five referenced base objects, all accessed through APPS synonyms: FF_COMPILED_INFO_F, FF_FORMULAS_F, FF_FORMULA_TYPES, FND_SESSIONS, and the HR_GENERAL package.

• FF_FORMULAS_F — the primary formula repository table, holding the formula text, name, description, effective dates, and business group.
• FF_FORMULA_TYPES — joined on FORMULA_TYPE_ID to supply the readable formula type name.
• FF_COMPILED_INFO_F — outer-joined on FORMULA_ID and EFFECTIVE_START_DATE to determine whether a compiled (verified) version of the formula exists.
• FND_SESSIONS — joined on the current USERENV('SESSIONID') to constrain the row to the effective date active for the session.
• HR_GENERAL — a package called at query time via HR_GENERAL.DECODE_LOOKUP to translate the formula type name through the FORMULA_TYPE lookup.

Key Columns

The view exposes eighteen columns. Identifiers and date-tracking attributes (ROW_ID, FORMULA_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, BUSINESS_GROUP_ID, LEGISLATION_CODE, FORMULA_TYPE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE) are passed through from FF_FORMULAS_F. The columns of greatest practical interest are:

• FORMULA_NAME, DESCRIPTION, FORMULA_TEXT — the human-readable identity and full source text of the formula.
• STICKY_FLAG — indicates whether the formula's effective dates should be extended under certain processing rules.
• FORMULA_TYPE — the decoded, translation-aware type label produced by HR_GENERAL.DECODE_LOOKUP, falling back to the raw FF_FORMULA_TYPES value when no lookup row exists.
• VERIFIED — a derived 'Y'/'N' indicator set to 'Y' when a matching row exists in FF_COMPILED_INFO_F.

Common Use Cases and Queries

The view is most often used to enumerate available formulas of a given type, to locate a formula by name, or to check whether a formula has been compiled before attempting to run a payroll or benefits process. A representative query listing all verified payroll formulas follows:

SELECT formula_name, formula_type, verified, effective_start_date
FROM   apps.ff_formulas_f_v
WHERE  formula_type = 'Oracle Payroll'
AND    verified = 'Y'
ORDER BY formula_name;

Because the join to FND_SESSIONS restricts output to the effective date of the current session, results are inherently date-sensitive and reflect the row the user would see in the FastFormula form. Queries intended for a specific past or future date should therefore be run with the appropriate effective-date context, or against FF_FORMULAS_F directly when historical, date-independent extraction is required.