Search Results ff_archive_item_context_pk




Overview
Explore in AI Chat

Overview

The HR.FF_ARCHIVE_ITEM_CONTEXTS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the HRMS (Human Resources Management System) module's FastFormula engine. Its primary role is to store supplemental contextual information required to uniquely identify and retrieve archived formula items. This is essential for the system's ability to correctly process and execute complex business rules, such as payroll calculations, where the same logical item (e.g., a specific earning or deduction) may have different archived instances depending on context variables like a specific tax unit, legislation, or date. The table functions as a child entity to FF_ARCHIVE_ITEMS, providing the necessary dimensionality for accurate formula resolution.

Key Information Stored

The table stores a concise set of columns that define the context for an archived item. The ARCHIVE_ITEM_ID is a foreign key that links the context record to its parent archive item in FF_ARCHIVE_ITEMS. The CONTEXT_ID is a foreign key to FF_CONTEXTS, identifying the type of context (e.g., 'TAX_UNIT_ID'). The CONTEXT column holds the actual value for that context type (e.g., '123' for a specific tax unit). The SEQUENCE_NO indicates the order in which contexts were applied, derived from the ff_route_context_usages table, which is critical for reconstructing the exact path used to locate the archived item. The primary key constraint FF_ARCHIVE_ITEM_CONTEXT_PK, defined on the combination of ARCHIVE_ITEM_ID and CONTEXT_ID, enforces the rule that a given archive item cannot have duplicate context types.

Common Use Cases and Queries

This table is primarily accessed during the retrieval and execution of archived formulas. A common use case is troubleshooting or auditing formula results, where a developer or analyst needs to understand why a specific archived item version was selected. A typical diagnostic query would join this table to its parent to see all context values for an archive item.

SELECT aic.archive_item_id,
       aic.sequence_no,
       aic.context,
       aic.context_id,
       fc.context_name
FROM hr.ff_archive_item_contexts aic,
     ff_contexts fc
WHERE aic.context_id = fc.context_id
AND aic.archive_item_id = &TARGET_ARCHIVE_ITEM_ID
ORDER BY aic.sequence_no;

Another critical scenario is during system upgrades or data migrations, where verifying the integrity and completeness of archived formula contexts ensures business rule continuity. Reporting on the distribution of contexts can also help in understanding formula complexity and customization.

Related Objects

  • Primary Key: FF_ARCHIVE_ITEM_CONTEXT_PK on (ARCHIVE_ITEM_ID, CONTEXT_ID).
  • Foreign Key (Parent Table): The table has a mandatory foreign key relationship to HR.FF_ARCHIVE_ITEMS via the ARCHIVE_ITEM_ID column. This enforces that every context record must be associated with a valid archived item.
  • Referenced Table (Context Definition): While not listed as a formal foreign key in the provided metadata, the CONTEXT_ID column is documented as a foreign key to FF_CONTEXTS, the master table defining all available context types within FastFormula.
  • Source of SEQUENCE_NO: The SEQUENCE_NO is derived from the ff_route_context_usages table, which defines the order of context evaluation for formula routes.