Search Results ff_ftype_context_usages_pk




Overview
Explore in AI Chat

Overview

The HR.FF_FTYPE_CONTEXT_USAGES table is a core intersection table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 architecture, specifically in the HR (Human Resources) schema. Its primary role is to manage the association between formula types and contexts. In the FastFormula engine, this relationship is critical as it defines the specific set of database items (contexts) that are available for use within formulas of a given type. By controlling this availability, the table ensures data integrity and relevance, preventing formulas from accessing inappropriate or undefined data elements. It functions as a fundamental configuration table within the formula definition subsystem.

Key Information Stored

The table is structurally simple, containing only two mandatory foreign key columns that together form its primary key. This design enforces a unique relationship between a formula type and a context. The FORMULA_TYPE_ID column is a foreign key referencing FF_FORMULA_TYPES, identifying a specific category or class of formulas, such as those used for payroll calculations or element input validation. The CONTEXT_ID column is a foreign key referencing FF_CONTEXTS, identifying a specific context that defines a namespace for database items, such as items related to an assignment, a payroll run, or an element entry. The combination stored in each row explicitly grants a formula of the specified type access to the database items within the specified context.

Common Use Cases and Queries

The primary use case is administrative and developmental, centering on the setup and audit of formula security and functionality. A common task is to verify which contexts are enabled for a particular formula type, which is essential when debugging formula compilation errors related to missing database items. Conversely, administrators may need to identify all formula types that can utilize a specific context. The table is also central when extending formula capabilities; adding a new context to a formula type requires an insert into this table. A foundational query to retrieve all associations is:

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
ORDER BY ft.formula_type_name, c.context_name;

Related Objects

HR.FF_FTYPE_CONTEXT_USAGES maintains defined foreign key relationships with two key master tables and is referenced by several database triggers. The documented relationships are:

  • Primary Key: FF_FTYPE_CONTEXT_USAGES_PK on columns (FORMULA_TYPE_ID, CONTEXT_ID).
  • Foreign Key (Parent: FF_FORMULA_TYPES): The FORMULA_TYPE_ID column references the FF_FORMULA_TYPES table, linking to the master list of formula types.
  • Foreign Key (Parent: FF_CONTEXTS): The CONTEXT_ID column references the FF_CONTEXTS table, linking to the master list of available contexts.
  • Referencing Objects: The table is referenced by database triggers FF_FTYPE_CONTEXT_USAGES_BRD and FF_FTYPE_CONTEXT_USAGES_BRU, which typically handle business rule validation or auditing on delete and update operations, respectively.