Results for “ff_formula_types_uk2”
14 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
HR.FF_FORMULA_TYPES is a seed data table in the Oracle E-Business Suite HR schema that holds the definition of formula types used by the Oracle Fast Formula (FF) engine. A formula type represents a logical grouping of formulas and, for example, includes categories such as Oracle Payroll, Input Value Validation, and Assignment Set. The type is combined with FF_CONTEXTS to determine which database items are available to a specific formula, making FF_FORMULA_TYPES a foundational reference object for payroll, compensation, and benefits calculations across EBS 12.1.1 and 12.2.2.
The table is registered under FND Design Data FF.FF_FORMULA_TYPES and resides in the APPS_TS_SEED tablespace, consistent with its role as seeded, low-volatility reference data. Based on the foreign key topology — with many dependent tables pointing to a single surrogate key — the object is best modeled as a hub in a Data Vault design, where FORMULA_TYPE_ID serves as the hub business key and the descriptive attributes act as satellite content.
Key Information Stored
The table contains nine documented columns. The most significant are:
- FORMULA_TYPE_ID (NUMBER) — Surrogate primary key and unique identifier of the formula type. This column anchors the FF_FORMULA_TYPES_PK constraint.
- FORMULA_TYPE_NAME (VARCHAR2(80)) — Business-key candidate enforced by the unique index FF_FORMULA_TYPES_UK2. It holds the user-recognizable name of the type, such as "Oracle Payroll" or "Assignment Set".
- TYPE_DESCRIPTION (VARCHAR2(80)) — Designer-facing description explaining the purpose of the formula type.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard Who (audit) columns capturing creation and last-modification metadata.
- ZD_EDITION_NAME — Editioning column present in the 12.2.2 physical schema, supporting the EBS edition-based redefinition architecture and appearing in both unique indexes.
The surrogate key FORMULA_TYPE_ID and the business key FORMULA_TYPE_NAME (each combined with ZD_EDITION_NAME for uniqueness) are the two documented unique identifiers, allowing consumers to resolve formula types either by numeric ID or by name.
Common Use Cases and Queries
FF_FORMULA_TYPES is typically joined to FF_FORMULAS_F to list the formulas belonging to a given type, or to FF_FTYPE_CONTEXT_USAGES to inspect which contexts expose database items to that type. Common reporting includes enumerating all seeded formula types, identifying formulas by category, and auditing context availability for payroll or validation logic.
A basic lookup query follows the documented Query Text:
SELECT FORMULA_TYPE_ID, FORMULA_TYPE_NAME, TYPE_DESCRIPTION FROM HR.FF_FORMULA_TYPES;- Joining to 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; - Resolving by business key:
... WHERE ft.FORMULA_TYPE_NAME = 'Oracle Payroll';
Related Objects
The table is referenced by several dependents through the FORMULA_TYPE_ID foreign key:
- FF_FORMULAS_F — References FF_FORMULA_TYPES.FORMULA_TYPE_ID; holds the formulas grouped under each type.
- FF_FORMULA_TYPE_COMPONENTS — References FORMULA_TYPE_ID; defines component composition of formula types.
- FF_FTYPE_CONTEXT_USAGES — References FORMULA_TYPE_ID; maps formula types to the contexts (and thus database items) available to them.
- FF_QP_REPORTS — References FORMULA_TYPE_ID; links QuickPay report definitions to their governing formula type.
- HR_S_FORMULAS_F, HR_S_FORMULA_TYPES, HR_S_QP_REPORTS, and HR_S_FTYPE_CONTEXT_USAGES — Shadow (HR_S) counterparts that mirror formula type relationships for seed-data synchronization.
Views and packages including FF_FORMULA_TYPES and FF_FORMULA_TYPES_WHO are also defined in the APPS schema, exposing the data for application-layer access alongside the base HR table. All relationships converge on FORMULA_TYPE_ID, confirming the table's role as a central reference hub within the Fast Formula framework.
-
TABLE: HR.FF_FORMULA_TYPES 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
Used to define groups of formulas to associate with formula contexts.
-
Used to define groups of formulas to associate with formula contexts.
-
TABLE: HR.FF_FORMULA_TYPES 12.2.2
-
eTRM - FF Tables and Views 12.2.2
Table and selection criteria combination used to define database items.
-
eTRM - FF Tables and Views 12.1.1
Table and selection criteria combination used to define database items.
-
eTRM - FF Tables and Views 12.1.1
Table and selection criteria combination used to define database items.
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - FF Tables and Views 12.2.2
Table and selection criteria combination used to define database items.