Search Results run_for_bg




Overview
Explore in AI Chat

Overview

HRI_OPL_WMV is an Oracle HRMS Intelligence (HRMSi) warehouse maintenance package delivered in the APPS schema. It is part of the Oracle Learning Management/Workforce Management "operational list" (OPL) processing infrastructure that populates and refreshes the HRMSi workforce management datamart tables — principally HRI_MB_WMV and its dependent assignment-level snapshot data. The package name suffix "WMV" denotes the Workforce Management view family, and "OPL" identifies it as an operational-list loader. Its central purpose is to collect assignment, payroll, and budget-related facts for a given business group over a specified collection window and to refresh the corresponding HRMSi summary tables either incrementally or through a full refresh.

The package declares a custom exception, ff_not_compiled, raised when a referenced Fast Formula has not been compiled, reflecting its dependence on Oracle Fast Formula for derived calculations during collection. The header also shows AUTHID CURRENT_USER, indicating invocations execute under the calling user's privileges rather than the definer's.

Key Procedures and Functions

  • run_for_bg — The central driver procedure. It accepts a business group identifier together with parameters controlling full refresh, FTE collection, headcount collection, and a collection date range (from/to). This is the entry point most commonly invoked by concurrent programs and by custom code when a targeted collection for a single business group is required. A caller searching for "run_for_bg" is typically attempting to launch or schedule this procedure directly.
  • range_cursor — Produces the dynamic SQL cursor string used by the payroll action framework to enumerate the assignments to be processed. It receives the payroll action identifier and returns the SQL text.
  • action_creation — Creates the individual assignment action rows for the payroll action, processing a range of persons (start person, end person) within a numbered chunk, enabling parallel processing.
  • init_code — Initialization hook executed at the start of a payroll action; receives the payroll action identifier and performs setup work such as loading session or control data.
  • archive_code — Archival hook invoked with the assignment action identifier and an effective date, responsible for moving or flagging processed rows for retention.
  • deinit_code — Cleanup hook executed at the conclusion of a payroll action, releasing resources and finalizing state.
  • shared_hrms_dflt_prcss — A concurrent-program entry point with standard errbuf/retcode outputs and parameters for collection from/to dates, full refresh, and two generic attributes. It provides the default HRMS collection processing invoked from the concurrent manager.

Tables Accessed

The package reads and writes several core HRMS and payroll tables through APPS synonyms. HRI_MB_WMV is the primary HRMSi workforce management table populated or refreshed. PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, and PAY_ASSIGNMENT_ACTIONS_S provide the payroll action and assignment action framework used to drive chunked, parallel collection runs. PER_ALL_ASSIGNMENTS_F supplies current assignment records, while PER_PERIODS_OF_SERVICE provides service-history context. PER_ASSIGNMENT_BUDGET_VALUES_F contributes budget and FTE figures, and PER_ASSIGNMENT_STATUS_TYPES is used to classify and filter assignment statuses. PLITBLM is an Oracle Applications PL/SQL index-by table type utility used for internal array processing, accounting for the run_for_bg parameter style.

Usage Notes

HRI_OPL_WMV is normally invoked indirectly by concurrent programs and HRMSi collection processes rather than interactively. The standard invocation path is through the concurrent program wrapping shared_hrms_dflt_prcss, which the payroll action framework coordinates via init_code, range_cursor, action_creation, archive_code, and deinit_code. The run_for_bg procedure is exposed as a direct business-group-level driver for targeted or custom refreshes. Because the package is documented as referenced by no other packages, it is essentially an invocation endpoint. Custom code calling run_for_bg should supply a valid business group, a Y/N full-refresh indicator, FTE and headcount collection flags, and a bounded date range, and should run during scheduled maintenance windows, as full refreshes of HRMSi tables are resource intensive. All procedures are sensitive to uncompiled Fast Formulas, which raise ff_not_compiled.