Search Results hri_ff_check_full




Overview

The concurrent program HRI_FF_CHECK_FULL is owned by the HRI - Human Resources Intelligence product family within Oracle E-Business Suite. Its user-facing name is HRI Fast Formula Checks (Full Refresh), and its documented purpose is to check the status of various HRI Fast Formulas during a full refresh operation. In practical terms, the program validates that the Fast Formulas on which Human Resources Intelligence depends are present, valid, and in a state suitable for the HRI full-refresh data collection process.

Under the ETRM 12.2.2 metadata, the HRI product is flagged as Obsolete, though the concurrent program itself remains documented as Enabled: Yes. This reflects the broader lifecycle position of the Human Resources Intelligence module, whose functionality was progressively superseded by later Oracle HR analytics and reporting offerings. Nevertheless, in supported 12.1.1 and 12.2.2 environments where HRI components remain deployed, the program continues to be referenced by HRI refresh flows. The "Full Refresh" qualifier in the name distinguishes it from incremental variants: the check is designed to run as part of a complete rebuild of HRI data rather than a delta update, and it therefore validates the complete set of Fast Formulas used by the refresh.

Execution Details

The documented execution attributes of the program are as follows:

  • Execution Method: PL/SQL Stored Procedure
  • Argument Method: Standard
  • Executable: HRI_FF_CHECK_FULL
  • Execution File: HRI_BPL_FAST_FORMULA.FASTFORMULA_CHECK_FULL
  • Executable User Name: HRI_FF_CHECK_FULL
  • Product: HRI - Human Resources Intelligence
  • Enabled: Yes

The executable name and execution file indicate that the program is implemented as a PL/SQL package procedure. The execution file reference HRI_BPL_FAST_FORMULA.FASTFORMULA_CHECK_FULL implies a package named HRI_BPL_FAST_FORMULA exposing a procedure FASTFORMULA_CHECK_FULL, which performs the actual validation logic. No subroutine name is documented. Because the execution method is PL/SQL Stored Procedure with the Standard argument method, the program is submitted through the standard concurrent manager infrastructure and does not require a host-language executable or a special argument-generation routine.

How to Run

The program is submitted from the standard Submit Requests (SRS) window in Oracle EBS, either directly by a user or as a component of a larger HRI full-refresh request set. It is typically scheduled to execute before or alongside the HRI data collection programs so that formula validation failures surface early in the refresh cycle. Because the Argument Method is Standard, any parameters defined for the program are presented on the SRS parameters form in the normal manner. The ETRM documentation does not enumerate specific parameters; where the program is invoked internally by a refresh request set, parameter values are normally supplied by the parent process. Administrators should confirm the responsibility and request group assignment, since the HRI product is documented as obsolete and menu availability may vary between 12.1.1 and 12.2.2 installations. Diagnostic output is generally reviewed through the concurrent request log and output file.

Related Objects

The program is closely associated with the HRI Fast Formula infrastructure, specifically the HRI_BPL_FAST_FORMULA package that contains the executed procedure. Related components include the other HRI refresh concurrent programs that make up the full-refresh request set, the Fast Formula definitions validated by this check, and the HRI data collection and extraction programs that consume the validated formulas. Administrators investigating failures should review the Fast Formula setup (via the Fast Formula responsibility) alongside the concurrent request log.