Results for “formula_text”

50+ results




Overview
Explore in AI Chat

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

Overview

FF_FORMULAS_X is a date-effective (versioned) view owned by the APPS schema within the FastFormula (FF) product module of Oracle E-Business Suite. It exposes the currently active definition of every FastFormula stored in the underlying formula repository at the moment the view is queried. In EBS 12.1.1 and 12.2.2, FastFormula underpins payroll calculations, compensation plans, benefits eligibility, accrual plans, absence management, and human resources rule processing, so the view serves as the principal reporting and integration surface for formula definitions.

The view is documented in ETRM as VALID with the description "Date-effective view." It is exposed as a security-enabled filtered interface to the base formula table: consumers querying FF_FORMULAS_X automatically receive only the formula version whose effective date range brackets the current system date (TRUNC(SYSDATE)). This eliminates the need for callers to write their own date-range predicates and guarantees a single, consistent "as of today" result set for both concurrent programs and ad hoc SQL.

Underlying Base Objects

The view is defined solely over the synonym FF_FORMULAS_F (the base FastFormula table, typically APPS.FF_FORMULAS_F). Its defining query is:

Because the filter is applied against SYSDATE, the view is not a simple projection: it is a runtime-filtered date-effective view. Records with an EFFECTIVE_START_DATE in the future or an EFFECTIVE_END_DATE in the past are excluded. Historical or future-dated formula versions must therefore be retrieved directly from FF_FORMULAS_F, which retains the complete version history keyed by FORMULA_ID and effective dates.

Key Columns

  • FORMULA_ID — Unique identifier for a formula (shared across all its date-effective versions).
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — Validity window of the version; the pair bounds the SYSDATE predicate.
  • FORMULA_NAME — User-facing name used to reference the formula in payroll and HR configuration.
  • FORMULA_TYPE_ID — Foreign key to FF_FORMULA_TYPES, identifying the formula category (e.g., Oracle Payroll, QuickPaint).
  • FORMULA_TEXT — The full source text of the FastFormula, the column most commonly searched for pattern or keyword analysis.
  • BUSINESS_GROUP_ID — Owning business group; NULL or 0 indicates a seed/global formula.
  • LEGISLATION_CODE — Territory the formula applies to (e.g., US, GB), important for localisation.
  • STICKY_FLAG — Indicates whether the compiled formula is retained in memory across sessions.
  • COMPILE_FLAG — Signals whether the formula requires (re)compilation.
  • Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE for change tracking.

Common Use Cases and Queries

Typical uses include inventorying active formulas, auditing localised versus seeded definitions, searching formula source, and feeding integration extracts. When a user searches on formula_text, the intent is usually keyword discovery within formula logic.

List all active formulas of a given type for a legislation:

  • SELECT formula_name, formula_type_id, legislation_code
    FROM apps.ff_formulas_x
    WHERE legislation_code = 'US';

Search for formulas whose source references a specific database item or function:

  • SELECT formula_id, formula_name, formula_text
    FROM apps.ff_formulas_x
    WHERE UPPER(formula_text) LIKE '%DATABASE_ITEM%';

Retrieve the current active definition of a single named formula:

  • SELECT formula_text
    FROM apps.ff_formulas_x
    WHERE formula_name = 'US_PAYROLL_TAX';

To examine historical versions, query FF_FORMULAS_F directly, since FF_FORMULAS_X returns only rows effective as of the current date. All queries should be qualified with the APPS schema and respect the standard EBS read-only reporting conventions.