Search Results context_id

Overview

The HR.FF_CONTEXTS table is a core metadata repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 architecture, specifically for the Oracle HRMS and Payroll modules. It serves as the master definition table for formula contexts. A context is a unique identifier that describes the business objects or entities a formula can act upon, such as an employee, an assignment, or a payroll run. By defining these contexts, the system establishes the framework for how formulas retrieve and process data, ensuring calculations are performed against the correct data scope and relationships. This table is part of the APPS_TS_SEED tablespace, indicating its role as a fundamental, seeded setup component.

Key Information Stored

The table stores the essential attributes that define a formula context. The primary and most critical column is CONTEXT_ID (NUMBER), which serves as the system's unique numeric identifier for each context record. The CONTEXT_NAME (VARCHAR2(30)) provides the unique, human-readable name for the context, such as 'EMPLOYEE' or 'ASSIGNMENT'. The CONTEXT_LEVEL (NUMBER) is a unique power-of-two value used internally for bitmask operations and context combination logic. Finally, the DATA_TYPE (VARCHAR2) column specifies the data type of the context value, typically 'N' for number, 'T' for text, or 'D' for date, which governs how context values are handled within formulas.

Common Use Cases and Queries

This table is primarily referenced during the design, debugging, and analysis of FastFormula logic. Common scenarios include identifying all available contexts for formula development or troubleshooting context-related errors in payroll calculations. A fundamental query retrieves the complete list of defined contexts:

SELECT CONTEXT_ID, CONTEXT_NAME, DATA_TYPE FROM HR.FF_CONTEXTS ORDER BY CONTEXT_NAME;

To investigate the usage of a specific context, such as one related to assignments, a developer or analyst might join this table with its dependent usage tables. Furthermore, the CONTEXT_ID is a key lookup value used by various formula-related APIs and setup interfaces to correctly associate contexts with formula types, functions, and balance definitions.

Related Objects

As a central metadata table, HR.FF_CONTEXTS is referenced by numerous other objects that utilize formula contexts. Key foreign key relationships, as documented, include: FF_FTYPE_CONTEXT_USAGES, FF_FUNCTION_CONTEXT_USAGES, and FF_ROUTE_CONTEXT_USAGES, which link contexts to formula types, functions, and routes. Crucially, it is referenced by PAY_ACTION_CONTEXTS and PAY_BALANCE_CONTEXT_VALUES, directly tying context definitions to payroll action execution and balance initialization logic. The object also has associated database triggers (FF_CONTEXTS_BRD, _BRI, _BRU) for enforcing business rules during data manipulation.