Search Results per_fastformula_event




Overview
Explore in AI Chat

Overview

PER_FASTFORMULA_EVENTS_UTILITY is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its status is VALID, and it is classified under the generic OTHER API category in the documented ETRM metadata. The package functions as a utility layer that supports FastFormula event processing within the Oracle HRMS (Human Resource Management System) module of EBS. FastFormula is the rules and calculation engine used extensively throughout HRMS and Payroll for deriving values such as eligibility, rates, deductions, and assignment attributes. This utility package is responsible for resolving the identity of a formula in the FastFormula repository and for executing the event logic associated with a given formula, allowing other applications and packages to trigger formula-based processing programmatically rather than interactively.

The package is a relatively small component, exposing only two documented program units, but it acts as a shared service consumed by multiple modules. Its presence in the dependency chain of several Payroll and HR extract packages confirms that it is a foundational helper rather than a user-facing feature.

Key Procedures and Functions

The ETRM metadata documents four program units, of which two are named: PER_FASTFORMULA_EVENT and GET_FORMULA_ID.

  • PER_FASTFORMULA_EVENT — The principal event handler in the package. It performs the core action of evaluating or triggering a FastFormula event, applying the formula logic in the context of the calling business process. This procedure is the entry point used by dependent packages when they need formula-driven behavior to be executed as part of their own processing.
  • GET_FORMULA_ID — A lookup function that returns the internal identifier of a FastFormula record, most likely using the formula name and formula type as the basis for retrieval. This is a common pattern in HRMS utilities, where downstream logic requires the numeric formula ID rather than the human-readable formula name.

The remaining two program units are not individually named in the excerpted metadata; they supplement the above by supporting internal processing, validation, or exception handling. No parameter lists are asserted here, as they are not documented in the source material.

Tables Accessed

The package references the following tables through APPS synonyms:

  • FF_FORMULAS_F — The core FastFormula repository table holding formula definitions, including names and compiled text. Accessed by GET_FORMULA_ID and PER_FASTFORMULA_EVENT to locate and evaluate formulas.
  • FF_FORMULA_TYPES — Defines the categories of formulas (for example, Oracle Payroll, HR, or Benefits formula types). Used to qualify formula lookups so that the correct formula is resolved for a given context.
  • PER_ALL_ASSIGNMENTS_F — The date-tracked assignments table. Read when formula evaluation requires assignment context, such as assignment attributes passed into the formula inputs.
  • PER_ASSIGNMENT_STATUS_TYPES — Provides the status classification of an assignment, allowing formulas to branch on whether an assignment is active, terminated, or otherwise classified.
  • PLITBLM — A standard PL/SQL table type used as a generic collection structure. Its presence indicates that the package passes or returns collections internally, typically for batched or set-based processing.

Usage Notes

PER_FASTFORMULA_EVENTS_UTILITY is not typically invoked directly by end users. It is called programmatically by other PL/SQL packages, forms, or concurrent programs that require FastFormula-driven logic. The documented referencing packages include PAY_EOSURVEY_PKG, PER_CA_EE_EXTRACT_PKG, and PER_CA_EMP_EQUITY_PKG, all of which sit in the Payroll and Canadian HR extract space, indicating that the utility supports region-specific statutory and equity processing where formula evaluation is required.

Custom code that needs to locate or execute a FastFormula should generally prefer the documented public entry points of this package rather than querying FF_FORMULAS_F directly, since the utility encapsulates the resolution and execution logic. Because the package is part of the APPS schema and is not marked as a public API in the ETRM classification, extensions should treat it as an internal dependency and re-validate behavior after EBS patches or upgrades between 12.1.1 and 12.2.2, as formula event handling may be affected by HRMS patch levels.