Search Results ff_ftype_context_usages




Overview
Explore in AI Chat

Overview

The FF_FTYPE_CONTEXT_USAGES table is a core reference table within the Oracle E-Business Suite FastFormula (FF) module. It functions as a junction table that defines the permissible contexts for a specific formula type. In FastFormula, contexts represent the runtime environments or data sources available to a formula, such as payroll runs, element entries, or absence accruals. This table establishes the critical link between a defined formula type (e.g., a type of earnings calculation) and the specific contexts in which formulas of that type are allowed to execute. Its role is to enforce data integrity and control the valid combinations of formula logic and runtime data, ensuring formulas only operate within their intended functional boundaries.

Key Information Stored

The table's structure is minimal, consisting primarily of its two primary key columns which form the relationship. The FORMULA_TYPE_ID column stores the unique identifier for a formula type, as defined in the FF_FORMULA_TYPES table. The CONTEXT_ID column stores the unique identifier for a context, as defined in the FF_CONTEXTS table. The combination of these two columns is enforced as a unique primary key (FF_FTYPE_CONTEXT_USAGES_PK), meaning that any specific pairing of a formula type and a context can only be recorded once. This design ensures a clear, non-redundant mapping of which contexts are applicable to which formula types.

Common Use Cases and Queries

A primary use case is the validation performed by the application when a user assigns a context to a formula or when a formula is compiled and executed. The system references this table to confirm the context is valid for the formula's type. For reporting and administrative purposes, common queries involve joining to related tables to produce human-readable lists. For example, to list all contexts available for a given formula type name:

  • SELECT ft.formula_type_name, c.context_name
  • FROM ff_ftype_context_usages fcu,
  • ff_formula_types ft,
  • ff_contexts c
  • WHERE fcu.formula_type_id = ft.formula_type_id
  • AND fcu.context_id = c.context_id
  • AND ft.formula_type_name = 'Earnings Calculation';

Conversely, to audit which formula types can use a specific context, one would query by the context name, joining the same tables.

Related Objects

FF_FTYPE_CONTEXT_USAGES is centrally connected to two other key FastFormula reference tables via foreign key constraints, as documented in the ETRM metadata.

  • FF_FORMULA_TYPES: The table is linked via the foreign key from FF_FTYPE_CONTEXT_USAGES.FORMULA_TYPE_ID to FF_FORMULA_TYPES. This relationship ensures every formula type ID in the usages table corresponds to a valid, defined formula type.
  • FF_CONTEXTS: The table is linked via the foreign key from FF_FTYPE_CONTEXT_USAGES.CONTEXT_ID to FF_CONTEXTS. This relationship ensures every context ID referenced is a valid, defined context within the FastFormula engine.

These relationships make FF_FTYPE_CONTEXT_USAGES an essential bridge in the data model, sitting between the definition of formula types (FF_FORMULA_TYPES) and the definition of available runtime contexts (FF_CONTEXTS).