Search Results ff_formula_types_uk2




Overview
Explore in AI Chat

Overview

The HR.FF_FORMULA_TYPES table is a core reference table within the Oracle E-Business Suite (EBS) Human Resources and Payroll modules, specifically within the FastFormula engine. It serves as a master catalog for classifying formulas into distinct functional groups. Each record defines a formula type, such as 'Oracle Payroll', 'Input Value Validation', or 'Assignment Set'. This classification is critical for system organization, as the formula type, in conjunction with contexts defined in FF_CONTEXTS, determines the specific set of database items and business rules available for use within a formula. This ensures formulas are correctly scoped and can only reference data elements pertinent to their intended purpose, maintaining data integrity and functional logic.

Key Information Stored

The table's structure is designed to store definitional metadata for formula types. The primary data columns are FORMULA_TYPE_ID, a system-generated unique numeric identifier, and FORMULA_TYPE_NAME, an 80-character unique name for the type (enforced by the FF_FORMULA_TYPES_UK2 unique key). The TYPE_DESCRIPTION column provides a field for a descriptive note for implementers or designers. The table also includes standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing changes. The table is stored in the APPS_TS_SEED tablespace, indicating it is part of the application's seed data foundation.

Common Use Cases and Queries

This table is primarily referenced during the setup, administration, and troubleshooting of FastFormulas. Common operational scenarios include identifying all available formula types during a new implementation, auditing formula categorization, and resolving issues where a formula references incorrect database items. A fundamental query retrieves the complete list of defined types. The unique key FF_FORMULA_TYPES_UK2 on FORMULA_TYPE_NAME is particularly relevant for lookups, as shown in the sample query below which finds the ID for a specific formula type.

  • Listing All Formula Types: SELECT formula_type_id, formula_type_name, type_description FROM hr.ff_formula_types ORDER BY 2;
  • Finding a Specific Type by Name (using UK2): SELECT * FROM hr.ff_formula_types WHERE formula_type_name = 'Oracle Payroll';
  • Joining to Child Formulas: SELECT ft.formula_type_name, f.formula_name FROM hr.ff_formula_types ft, hr.ff_formulas_f f WHERE ft.formula_type_id = f.formula_type_id;

Related Objects

HR.FF_FORMULA_TYPES acts as a parent table in several key relationships, primarily through its primary key, FORMULA_TYPE_ID. The documented foreign key relationships show it is referenced by core FastFormula objects. The FF_FORMULAS_F table links every individual formula to its governing type. The FF_FTYPE_CONTEXT_USAGES table defines which contexts are valid for a given formula type, controlling available database items. The FF_QP_REPORTS table uses it for QuickPaint report formulas. Additionally, the metadata indicates a relationship with FF_FORMULA_TYPE_COMPONENTS. These relationships underscore the table's central role in the formula architecture, ensuring referential integrity across the formula definition ecosystem.

  • FF_FORMULAS_F: Links via FORMULA_TYPE_ID. Stores the individual formula definitions.
  • FF_FTYPE_CONTEXT_USAGES: Links via FORMULA_TYPE_ID. Maps formula types to permissible contexts.
  • FF_QP_REPORTS: Links via FORMULA_TYPE_ID. Associates formula types with QuickPaint reports.
  • FF_FORMULA_TYPE_COMPONENTS: Links via FORMULA_TYPE_ID. Manages components associated with a formula type.