Search Results ff_contexts

Overview

The FF_CONTEXTS table is a core metadata repository within the Oracle E-Business Suite FastFormula (FF) engine. It serves as the master definition table for formula contexts, which are variables or parameters that allow formulas to be dynamically evaluated based on specific runtime data. For instance, a payroll calculation formula might require an EMPLOYEE_ID context to determine which employee's data to process. This table defines all such available contexts across the system, enabling the modular and reusable design of FastFormulas in modules like Oracle HRMS and Oracle Payroll. Its integrity is critical for ensuring formulas can correctly resolve their input parameters during execution.

Key Information Stored

The table's structure is designed to uniquely identify and name each context. The primary columns, as indicated by the primary key constraints, are CONTEXT_ID and CONTEXT_NAME. The CONTEXT_ID is the unique numeric identifier (primary key FF_CONTEXTS_PK), while CONTEXT_NAME is the unique textual name of the context (unique key FF_CONTEXTS_UK2), such as 'EMPLOYEE_ID', 'DATE_EARNED', or 'ASSIGNMENT_ID'. These two columns form the essential reference point for the FastFormula engine and related components to look up and validate context usage. The table likely contains additional descriptive columns not detailed in the excerpt, but these two are the definitive keys for all relationships.

Common Use Cases and Queries

This table is primarily referenced for setup, diagnostic, and impact analysis queries. Common scenarios include identifying all defined contexts in the system, troubleshooting formula compilation errors related to missing contexts, and analyzing which formulas or system components use a specific context before making changes. A fundamental query retrieves the master list of contexts:

• SELECT context_id, context_name FROM hr.ff_contexts ORDER BY context_name;

To investigate the usage of a specific context, one would join to the foreign key tables listed in the metadata, such as FF_FUNCTION_CONTEXT_USAGES, to see which formula functions are dependent on it. This is essential for understanding the downstream impact of any modification.

Related Objects

The FF_CONTEXTS table is a central reference point for numerous other FastFormula and payroll objects. As per the provided metadata, its CONTEXT_ID column is referenced as a foreign key by several important tables: FF_FTYPE_CONTEXT_USAGES (links contexts to formula types), FF_FUNCTION_CONTEXT_USAGES (links contexts to formula functions), FF_ROUTE_CONTEXT_USAGES (links contexts to formula routes), PAY_ACTION_CONTEXTS (links contexts to payroll actions), and PAY_BALANCE_CONTEXT_VALUES (stores specific values for contexts in balance calculations). This network of relationships underscores its role as the authoritative source for context definitions that integrate formulas with the broader HR and payroll data model.