Search Results ff_archive_item_contexts

Overview

The FF_ARCHIVE_ITEM_CONTEXTS table is a core data structure within the Oracle E-Business Suite FastFormula (FF) module. It functions as a supporting table to the FF_ARCHIVE_ITEMS table, storing the specific context values required to uniquely identify and retrieve archived formula items. In Oracle EBS, FastFormula is a powerful tool used to define complex business rules, particularly within the Human Resources (HR) and Payroll modules. When formulas are archived, the system must preserve not only the formula text but also the precise context (such as a specific legislative group, date, or assignment) under which it was valid. This table provides the mechanism to store those contextual identifiers, ensuring the correct archived formula can be located for audit, reporting, or historical analysis purposes.

Key Information Stored

The table's structure is designed to link a context value to a specific archived formula item. Its primary key is a composite of two columns, which underscores its fundamental purpose. The critical columns are:

• ARCHIVE_ITEM_ID: A foreign key column that links directly to the primary key (ARCHIVE_ITEM_ID) of the FF_ARCHIVE_ITEMS table. This identifies the specific archived formula to which the context belongs.
• CONTEXT_ID: Stores the identifier for a specific context value. This ID corresponds to a context defined within the FastFormula engine, such as a particular payroll, legislation, or date. The combination of ARCHIVE_ITEM_ID and CONTEXT_ID creates a unique record, defining one piece of context for an archived item.

Common Use Cases and Queries

The primary use case for this table is retrieving the complete definition of an archived formula, including its execution context. This is essential for historical reporting, debugging past payroll calculations, or meeting legislative audit requirements. A typical query would join this table to FF_ARCHIVE_ITEMS and potentially to context value tables to translate IDs into meaningful names. For example, to find all context for a specific archived formula, one might use:

SELECT fai.archive_item_id, faic.context_id
FROM ff_archive_items fai, ff_archive_item_contexts faic
WHERE fai.archive_item_id = faic.archive_item_id
AND fai.formula_id = :formula_id;

Another common pattern is verifying the existence of an archived formula for a precise set of contexts, which involves querying this table for matching CONTEXT_ID values linked to a candidate ARCHIVE_ITEM_ID.

Related Objects

The FF_ARCHIVE_ITEM_CONTEXTS table has a direct and documented foreign key relationship, defining its core dependency.

• FF_ARCHIVE_ITEMS: This is the primary parent table. The foreign key FF_ARCHIVE_ITEM_CONTEXTS.ARCHIVE_ITEM_ID references FF_ARCHIVE_ITEMS.ARCHIVE_ITEM_ID. An archived item in FF_ARCHIVE_ITEMS can have one or more associated context records in FF_ARCHIVE_ITEM_CONTEXTS. This relationship is enforced by the FF_ARCHIVE_ITEM_CONTEXT_PK primary key and the corresponding foreign key constraint.