Search Results execute_mt

Overview

GHR_PROC_FUT_MT is an Oracle EBS Applications (APPS) PL/SQL package that supports the "Process Futures" batch processing functionality within Oracle Human Resources / Public Sector payroll-adjacent processing. It is owned by the APPS schema and classified as an OTHER API in the ETRM metadata for release 12.2.2 (source header also present in 12.1.1, ghprocmt.pkh 120.1). The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, and its behavior can therefore depend on the caller's security context and group box (security profile) membership.

Its primary business purpose is to orchestrate the execution of a concurrent request that processes a defined set of "futures" actions for a given personnel office. The package determines batch sizing, splits work into threads, dispatches subordinate processing, routes error conditions, and enforces business rules such as the 355 rule and group box membership. A global boolean, g_skip_grp_box, is provided (referenced under bug# 4896738) to suppress errors when a user outside the relevant group box runs the process futures program.

Key Procedures and Functions

• EXECUTE_MT — The main entry point, called from a concurrent program. It determines the batch size from the incoming parameters (personnel office, batch size, and thread size) and calls sub programs to perform the actual processing. Returns the standard concurrent manager error buffer and return code.
• SUB_PROC_FUTR_ACT — A subordinate ("sub procedure") invoked by EXECUTE_MT to process futures actions for a specific session, batch number, and parent request ID, supporting the threaded/batched execution model. It returns errbuf and retcode to the caller.
• CREATE_GHR_ERRORLOG — Writes diagnostic and error information to the GHR process log, capturing the program name, log text, message name, and log date for later review and troubleshooting.
• ROUTE_ERRORED_SF52 — Routes an errored SF52 (Standard Form 52, Request for Personnel Action) record, accepting the GHR_PA_REQUESTS row and error text and returning a result indicator. It supports the routing history/movement of failed personnel action requests.
• VERIFY_355_BUSINESS_RULE — Evaluates the "355" business rule for a given person and effective date, returning a result string. This enforces personnel action eligibility/validation logic during futures processing.

Tables Accessed

• GHR_PA_REQUESTS — The personnel action request records being processed, routed, or errored (SF52 routing).
• GHR_POIS — Personnel office identifiers used to scope the batch by personnel_office_id.
• GHR_PROCESS_LOG / GHR_PROCESS_LOG_S — Target of create_ghr_errorlog for logging program execution and errors.
• GHR_PA_ROUTING_HISTORY — Records routing history when errored requests are re-routed.
• GHR_MTS_TEMP — Temporary staging table used during multi-threaded futures processing.
• GHR_NATURE_OF_ACTIONS — Provides nature-of-action definitions applied to requests.
• FND_SESSIONS — Used to resolve concurrent request/session context for batched execution.
• PER_ALL_PEOPLE_F and PER_POSITION_EXTRA_INFO — Person and position data used for rule evaluation.
• DBMS_LOCK, DUAL, PLITBLM — Utility calls for locking/serialization and standard dual-table selects.

Usage Notes

GHR_PROC_FUT_MT is designed to be invoked from a concurrent program rather than directly by end users; the concurrent manager supplies the personnel office, batch size, and thread size parameters. It is referenced by one other package in the ETRM metadata, indicating internal dependency rather than a broadly published API. Because it runs AUTHID CURRENT_USER and depends on personnel office and group box security, callers must ensure the submitting user has the appropriate security profile. Customizations should avoid modifying this package's logic directly and instead extend behavior where supported; error handling and re-routing of SF52 requests can be monitored through GHR_PROCESS_LOG.