Search Results log_process_end




Overview
Explore in AI Chat

Overview

HRI_BPL_CONC_LOG is a shared logging and process-tracking utility within the Oracle EBS HRMS (Human Resources Management System) module. Its name derives from its role as a Business Process Library (BPL) concurrent logging package, and it is declared with AUTHID CURRENT_USER, meaning that its SQL executes with the privileges of the calling schema rather than the package owner. The package supplies a standardized mechanism by which HRMS batch processes and concurrent programs record diagnostic output, transactional context, and processing milestones into the message log infrastructure. Rather than each program implementing its own logging code, HRI_BPL_CONC_LOG centralizes this behavior so that output is consistent, queryable, and traceable. In Oracle EBS 12.1.1 and 12.2.2 this package is a foundational dependency for numerous HRMS batch components; the ETRM metadata records that it is referenced by fifteen other packages, confirming its role as a lower-level service rather than an end-user-facing API.

Key Procedures and Functions

  • GET_LAST_COLLECT_TO_DATE — Returns the last collection date recorded for a given process code and table, allowing batch processes to resume incremental processing from a known point.
  • DELETE_PROCESS_LOG — Removes log entries associated with a supplied process code, used to purge stale or superseded run information.
  • OUTPUT — Overloaded generic output procedure that writes formatted or plain text to the concurrent program log, optionally applying a column list and formatting mode.
  • DBG — Writes a message to the log only when debug is enabled, keeping verbose diagnostics out of normal production runs.
  • RECORD_PROCESS_START — Persists the start information for a named process, establishing the run's baseline for later end-of-process accounting.
  • LOG_PROCESS_INFO — The principal logging entry point, capturing message type, package name, message grouping, SQL error code, note, effective date, and a broad set of HRMS foreign-key references such as assignment, person, job, location, event, supervisor, person type, formula, and other reference identifiers.
  • FLUSH_PROCESS_INFO — Flushes buffered process information to the persistent log table, ensuring messages accumulated in memory are written out, typically before commit or at a defined checkpoint.
  • LOG_PROCESS_END — Records the completion of a process, closing out the run started by RECORD_PROCESS_START.
  • OBSOLETED_MESSAGE — Retained for backward compatibility, providing standard wording for messages associated with obsoleted functionality.

Tables Accessed

The package operates against HRI_ADM_MSG_LOG, the primary message log table into which informational, error, and process-tracking rows are written and from which entries are deleted. HRI_ADM_MSG_LOG_S is the corresponding sequence source used to generate log identifiers. HRI_ADM_MTHD_ACTIONS supplies method and action metadata consulted during logging operations. DUAL is used for scalar evaluations such as the default effective date of TRUNC(SYSDATE), and PLITBLM is the PL/SQL table-to-database bulk transfer facility leveraged for efficient set-based writes. All access occurs through APPS synonyms.

Usage Notes

HRI_BPL_CONC_LOG is normally invoked indirectly. HRMS concurrent programs and batch processes call RECORD_PROCESS_START at initiation, LOG_PROCESS_INFO and OUTPUT throughout execution, FLUSH_PROCESS_INFO at commit boundaries, and LOG_PROCESS_END at completion. Because fifteen packages depend on it, customizations that wrap or extend standard HRMS batch logic will frequently encounter it. Direct modification is not advisable; the supported extension pattern is to call the public procedures from custom code while preserving the package's own source. The FLUSH_PROCESS_INFO procedure is particularly relevant to callers that buffer messages, since unwritten log entries are lost if an unexpected termination occurs before a flush.