Search Results ff_formula_type_components_pk




Overview
Explore in AI Chat

Overview

The HR.FF_FORMULA_TYPE_COMPONENTS table is a core data dictionary object within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically for the FastFormula engine. It functions as a metadata repository that defines the building blocks, or components, for formula types. A formula type represents a category of business logic, such as a payroll calculation or an absence accrual rule. This table catalogs the specific inputs, outputs, and potentially other elements that formulas of a given type can utilize or produce. Its primary role is to enforce structure and data integrity, ensuring that formulas are constructed with valid, predefined components, which is critical for the accurate and consistent execution of complex business rules across EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure captures essential metadata for each component. The COMPONENT_ID, combined with ZD_EDITION_NAME for Edition-Based Redefinition (EBR) support, forms the primary key (FF_FORMULA_TYPE_COMPONENTS_PK), guaranteeing uniqueness. The COMPONENT_NAME and COMPONENT_TYPE fields identify the component and classify its role (e.g., as an input or output). The COMPONENT_DATATYPE defines the expected data format (e.g., NUMBER, DATE, TEXT), which is vital for formula validation. The FORMULA_TYPE_ID is a foreign key that links the component to its parent definition in the FF_FORMULA_TYPES table. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track audit information for each record.

Common Use Cases and Queries

This table is primarily accessed for system configuration, troubleshooting, and impact analysis. A common administrative task is to audit all components defined for a specific formula type to understand its structure. For example, to list all inputs for a payroll calculation formula type, one might execute a query joining to FF_FORMULA_TYPES. Developers or functional consultants may query this table to identify the correct datatype and name of a component before referencing it in a formula. Furthermore, understanding component definitions is essential when diagnosing formula compilation errors related to invalid variable usage. A foundational query to extract all component metadata is:

SELECT ft.FORMULA_TYPE_NAME, ftc.*
FROM ff_formula_type_components ftc,
     ff_formula_types ft
WHERE ftc.formula_type_id = ft.formula_type_id
AND ft.formula_type_name = '<Type_Name>'
ORDER BY ftc.component_type, ftc.component_name;

Related Objects

The FF_FORMULA_TYPE_COMPONENTS table has a direct and critical relationship with the FF_FORMULA_TYPES table, which holds the master definition of formula types. The relationship is enforced by a foreign key constraint where the FORMULA_TYPE_ID column in FF_FORMULA_TYPE_COMPONENTS references the FORMULA_TYPE_ID column in FF_FORMULA_TYPES. This ensures that every component is associated with a valid, existing formula type. While the provided dependency information indicates no other objects reference this table, it is intrinsically linked to the runtime FastFormula engine. The components defined here are used to validate and compile the formula text stored in related tables like FF_FORMULAS, ensuring the logic conforms to the declared structure.