Search Results ff_function_context_usages_pk

Overview

The FF_FUNCTION_CONTEXT_USAGES table is a core metadata repository within the Oracle E-Business Suite FastFormula (FF) engine. It defines the specific contexts that must be available for a given FastFormula function to execute successfully. In Oracle EBS, FastFormula is a declarative tool used to define complex business rules across modules like Payroll, Compensation, and Human Resources. This table acts as a critical link between the function definitions (stored in FF_FUNCTIONS) and the contexts (stored in FF_CONTEXTS) that provide the runtime data values, such as assignment details or payroll elements. Its role is to enforce data integrity and ensure that all necessary input parameters are resolved when a formula is evaluated.

Key Information Stored

The table's structure is designed to map functions to their required contexts. The primary columns are FUNCTION_ID, which is a foreign key to FF_FUNCTIONS.FUNCTION_ID, and CONTEXT_ID, a foreign key to FF_CONTEXTS.CONTEXT_ID. The SEQUENCE_NUMBER column, part of the primary key, dictates the order in which contexts are processed or validated. This table does not store actual data values; instead, it stores the metadata defining the dependencies. The dual primary and unique key constraints (FF_FUNCTION_CONTEXT_USAGES_PK and FF_FUNCTION_CONTEXT_USAGES_UK2) ensure that each context-to-function mapping is unique and properly sequenced.

Common Use Cases and Queries

A primary use case is during the development and troubleshooting of custom FastFormulas. A developer can query this table to verify which contexts a specific function requires, ensuring the calling formula passes the correct inputs. Database administrators or functional consultants may also query it to audit formula dependencies before migrating or patching. A typical query to list all contexts for a function, given its name, would be:

• SELECT fc.context_name FROM ff_contexts fc, ff_functions f, ff_function_context_usages fcu WHERE f.function_id = fcu.function_id AND fcu.context_id = fc.context_id AND f.function_name = 'MY_FUNCTION_NAME';

Another common pattern is to identify all functions that depend on a specific context, which is valuable for impact analysis when a context definition is modified.

Related Objects

FF_FUNCTION_CONTEXT_USAGES is centrally linked to two other key FastFormula metadata tables via foreign key relationships. The FF_FUNCTIONS table contains the definition of the formula functions themselves, such as their names and return types. The FF_CONTEXTS table stores the definitions of all available contexts within the system. This table is also referenced by the primary key constraint FF_FUNCTION_CONTEXT_USAGES_PK and the unique key constraint FF_FUNCTION_CONTEXT_USAGES_UK2. Understanding the relationship between these three tables is fundamental for anyone performing advanced FastFormula customization or support in Oracle EBS.