Search Results update_process_log

Overview

APPS.PQH_PROCESS_LOG_API is a public PL/SQL API belonging to the Oracle E-Business Suite HRMS family, specifically the Oracle Payroll/Advanced Benefits process logging infrastructure (the PQH prefix is associated with the Oracle Human Resources "Public Sector/HR" and payroll processing frameworks). Its core purpose is to provide a controlled, reusable interface for creating, maintaining, and removing rows from the PQH_PROCESS_LOG table, which stores running diagnostic and audit information about batch and background processes. The package is classified as an API in the ETRM metadata for both 12.1.1 and 12.2.2, indicating it is intended to be called by other Oracle modules and by custom code rather than executed directly by end users. The source header identifies the underlying file as pqplgapi.pkb, a long-standing component of the HRMS code base.

Key Procedures and Functions

The package body exposes three documented procedures, all of which operate against the process log data model:

• CREATE_PROCESS_LOG — Inserts a new row into the process log. Its signature accepts a wide range of attributes including module code, transaction ID, master process log ID, message text and message type, batch status and batch start/end dates, a transaction table route ID, log context, and a DFF-style information category with twenty descriptive flexfield segments. An OUT parameter returns the generated process log ID.
• UPDATE_PROCESS_LOG — Modifies an existing process log record, allowing callers to amend status, messages, dates, or descriptive attributes after the row has been created.
• DELETE_PROCESS_LOG — Removes a process log entry, supporting housekeeping and cleanup of transient diagnostic data. This is the procedure most relevant to the "delete_process_log" search, and it is the sanctioned method for purging log rows rather than issuing direct DML.

Tables Accessed

The package reads and writes the PQH_PROCESS_LOG table, referenced through an APPS synonym. CREATE_PROCESS_LOG performs the insert, UPDATE_PROCESS_LOG performs the update, and DELETE_PROCESS_LOG performs the delete. The table holds the log context, batch status, timestamps, and the twenty information columns populated by the create routine. Beyond this single documented table, the package may consult HRMS lookup and validation structures, but ETRM records only PQH_PROCESS_LOG as a referenced object.

Usage Notes

PQH_PROCESS_LOG_API is referenced by five other packages, confirming its role as a shared utility within the HRMS processing stack. It is typically invoked from batch and concurrent program logic, payroll process controllers, and custom PL/SQL that needs to log or clear processing diagnostics. A common pattern is to call CREATE_PROCESS_LOG at the start of a batch run, UPDATE_PROCESS_LOG on completion or failure, and DELETE_PROCESS_LOG during purge routines. The API abstracts the table structure and enforces consistent column population, so customizations should call these procedures instead of writing directly to PQH_PROCESS_LOG. When invoking DELETE_PROCESS_LOG, callers should ensure the target log row is no longer required by any parent process, since the deletion is physical and the API does not implement an archival step. All three procedures are callable from the APPS schema only.