Search Results ff_compiled_info_f_pk

Overview

FF_COMPILED_INFO_F is a table in the HR schema of Oracle E-Business Suite, belonging to the FastFormula (FF) product family. It stores the compiled versions of user-defined formulas. FastFormula is the rules and calculations engine used across Oracle EBS applications — Oracle Payroll, Oracle Human Resources, Oracle Advanced Benefits, Oracle Time and Labor, and Oracle Compensation Workbench all depend on it to evaluate user-authored business rules. Source formulas originate as text, for example in FF_FORMULAS_F, and are parsed then compiled before they can be executed at runtime. FF_COMPILED_INFO_F retains the compiled output together with compilation statistics so that the runtime engine does not need to recompile formulas on every execution.

The table is date-effective, controlled by EFFECTIVE_START_DATE and EFFECTIVE_END_DATE, and is edition-enabled, as reflected by the ZD_EDITION_NAME column. The DateTrack and eBusiness Suite editioning patterns therefore apply to this object, and queries that do not constrain date and edition context may return more than one logical row per formula.

From a Data Vault modeling perspective, the mined relationship data classifies this object as standalone, with no foreign key dependencies documented within the ETRM structure. It may be treated as a satellite carrying descriptive compiled-formula attributes, keyed by the business key of the formula rather than by a synthetic surrogate.

Key Information Stored

The table documents eight columns. The primary key, FF_COMPILED_INFO_F_PK, is a composite business-like key rather than a single-column surrogate, spanning FORMULA_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE, extended in the 12.2.2 physical schema to include ZD_EDITION_NAME.

• FORMULA_ID — identifier of the formula whose compiled form is stored; the principal join key back to the formula definition.
• EFFECTIVE_START_DATE and EFFECTIVE_END_DATE — the DateTrack effective period for the compiled record, allowing history to be preserved across formula revisions.
• ZD_EDITION_NAME — editioning column supporting Online Patching introduced in EBS 12.2. This column does not exist in 12.1.1, where the primary key comprises only the three columns above.
• COMPILED_TEXT — the compiled representation of the formula, the core payload executed by the runtime engine.
• TEXT_LENGTH — length of the compiled or source text, useful for size analysis and capacity planning.
• SELECT_STATEMENT_COUNT — number of SQL select statements referenced by the compiled formula; relevant for performance tuning.
• FDIU_ENTRY_COUNT — count of Formula Database Item Unit entries associated with the compilation, reflecting the number of database items the formula depends upon.

Common Use Cases and Queries

The primary use case is diagnostics: determining whether a formula has been compiled, when, and what the compilation contained. A typical query retrieves the current compiled row for a given formula name, joining to the formula definition table:

• Compilation status: select FORMULA_ID, TEXT_LENGTH, SELECT_STATEMENT_COUNT from FF_COMPILED_INFO_F where FORMULA_ID = :p_formula_id and trunc(sysdate) between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE.
• Identifying formulas with heavy SQL usage: select FORMULA_ID, SELECT_STATEMENT_COUNT from FF_COMPILED_INFO_F where SELECT_STATEMENT_COUNT > 0 order by SELECT_STATEMENT_COUNT desc.
• Edition-aware reporting: add ZD_EDITION_NAME = 'ORA$BASE' or the applicable edition for 12.2 environments.
• Inventory reporting: aggregate counts of compiled formulas per business group, useful during upgrades and patch impact analysis.

Related Objects

The following objects are significant when working with FF_COMPILED_INFO_F:

• FF_FORMULAS_F — master definition of formulas; join on FORMULA_ID to resolve formula names and types.
• FF_FORMULA_TYPES — categorizes formulas (Oracle Payroll, HR, Benefits, and so on).
• FF_FORMULA_ROUTES — controls which formulas are effective for which legislative contexts.
• FF_DATABASE_ITEMS — the database items referenced by FDIU_ENTRY_COUNT.
• FF_GLOBALS_F and FF_CONTEXTS — support the compilation environment by supplying global values and context definitions.
• FF_EXECUTION_F — logs runtime execution of compiled formulas.

Direct DML against FF_COMPILED_INFO_F should be avoided; compilation is managed through the FastFormula application and its APIs.