Search Results hri_bpl_fast_formula




Overview
Explore in AI Chat

Overview

HRI_BPL_FAST_FORMULA is an Oracle Applications (APPS) PL/SQL package belonging to the Oracle Human Resources (HR) product family, specifically the Performance Management and Fast Formula subsystem. The package encapsulates the business logic that supports the migration of Oracle HRMS Performance Management appraisal data from the legacy, pre-Fast Formula model to the Fast Formula based calculation engine introduced with the Self-Service Performance Appraisal functionality.

In Oracle EBS 12.1.1 and 12.2.2 the appraisal scoring and rating behavior of an appraisal template is driven by a Fast Formula. When a customer previously maintained appraisal scoring rules using the older table-based configuration, those rules must be converted into equivalent Fast Formula definitions so that the Self-Service Performance Appraisal module can compile and evaluate them. HRI_BPL_FAST_FORMULA provides the programmatic entry points used to generate, verify, and manage these performance appraisal Fast Formulas at business group level. It also provides the validation logic used to reconcile the state of the generated formulas, which is why it is directly relevant to checks such as fastformula_check_full.

Key Procedures and Functions

The package exposes eight documented program units, two of which are declared exceptions (SUB_PROCESS_NOT_FOUND and SUB_PROCESS_FAILED) used to handle errors raised in spawned sub-processes.

  • GNRT_BG_SS_PRFRMNCE_APPRSL_FF (procedure) — Generates the Self-Service Performance Appraisal Fast Formulas for a specified business group.
  • GNRT_SS_PRFRMNCE_APPRSL_FF (function) — Function form of the generation routine, returning a Boolean success indicator; the business group argument is optional and defaults to NULL.
  • GNRT_SS_PRFRMNCE_APPRSL_FF (procedure) — Concurrent-program style overload returning errbuf and retcode for use by the concurrent manager.
  • CHECK_FAST_FORMULA_EXISTS (function) — Determines whether a named Fast Formula already exists for a given business group, returning a Boolean.
  • DELETE_PERFORMANCE_FORMULA (procedure) — Removes the performance appraisal formula associated with a specific business group.
  • DELETE_ALL_PRFRMNC_FORMULAS (procedure) — Removes all performance appraisal Fast Formulas maintained by the package.
  • FASTFORMULA_CHECK_FULL (procedure) — Full verification routine that checks the integrity and completeness of the generated performance appraisal Fast Formulas; returns errbuf and retcode.
  • FASTFORMULA_CHECK_INCR (procedure) — Incremental verification routine performing the same validation over a narrower scope; returns errbuf and retcode.

Tables Accessed

The package operates across the Fast Formula and Performance Management schemas through APPS synonyms. FF_FORMULAS_F stores the Fast Formula definitions that the package creates and removes. FF_FORMULA_TYPES identifies the formula type under which the performance appraisal formulas are registered. FF_COMPILED_INFO_F holds compiled formula information validated during the check routines. PER_APPRAISAL_TEMPLATES, PER_RATING_SCALES, and PER_RATING_LEVELS supply the appraisal template and rating configuration from which the generated formulas derive their scoring logic and value sets. FND_NEW_MESSAGES is used to raise user-facing error messages when sub-processes fail or validation errors are detected.

Usage Notes

HRI_BPL_FAST_FORMULA is primarily an internal support package rather than a general-purpose API. It is invoked during the migration path that converts legacy appraisal scoring configuration into Fast Formulas, most commonly through seeded concurrent programs that call the GNRT_SS_PRFRMNCE_APPRSL_FF procedure overload. The FASTFORMULA_CHECK_FULL and FASTFORMULA_CHECK_INCR procedures are the diagnostic entry points used to confirm that generated formulas are present, syntactically valid, and complete; these are the routines surfaced when a user runs a fast formula validation check for performance appraisal data. The package should generally not be called directly from custom code without understanding the migration state of the business group, because it writes directly to the Fast Formula tables rather than through the standard FF_FORMULA_LOADER interface. In 12.2.2 the same package is delivered under the APPS schema with no evident functional change from the 12.1.1 signature set.