Search Results message_log_proc




Overview
Explore in AI Chat

Overview

The APPS.PER_SALADMIN_ANALYTICS_PKG package is a salary administration analytics utility that belongs to the Oracle Human Resources (PER) product family. Its primary purpose, evident from the embedded header comment (pesalanl.pkh 120.1), is to replace the materialized view HR_MBS_WRKFC_JCX_MV with a physical table, PER_SALADMIN_ANALYTICS, specifically for the Oracle EBS 12.2 release architecture. The 12.2 online patching (adop) and editioning model makes traditional materialized view refreshes problematic, so this package consolidates salary administration data into a dedicated analytics table that can be selectively populated and made edition-aware.

The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoker rather than the definer. This is consistent with an object invoked from concurrent programs run as the APPS schema, and it aligns with the editioning requirements introduced in EBS 12.2. The package was authored with a public global variable Conc_Prog_Id used to track the concurrent program context, and it exposes a small, focused API of five documented procedures and functions.

Key Procedures and Functions

  • PER_SALADMIN_ANALYTICS_PROC — The main driver procedure. It performs the population of the PER_SALADMIN_ANALYTICS table, returning ERRBUF and RETCODE as OUT NOCOPY parameters so that it can be registered directly as the executable of a concurrent program. This is the entry point that replaces the legacy MV refresh.
  • MESSAGE_LOG_PROC — A diagnostic logging routine. It accepts a MESSAGE and a numeric STAGE identifier and routes output either to fnd_file (for concurrent program log/out files) or to hr_utility tracing. This is the procedure that the user's search term message_log_proc references.
  • CHECK_REFRESH_JOBS — A function returning a NUMBER that reports whether the PER_SALADMIN_ANALYTICS table is currently being populated. It is used to prevent concurrent, overlapping refreshes.
  • INSERT_REFRESH_JOBS — Inserts a marker row into PER_SALADMIN_ANALYTICS at the start of population, signalling that a refresh is in progress.
  • DELETE_REFRESH_JOBS — Removes that marker row once population completes, clearing the in-progress flag.

Tables Accessed

The package reads salary administration master and transactional data through APPS synonyms including PAY_ELEMENT_TYPES_F, PAY_GRADE_RULES_F, PAY_INPUT_VALUES_F, PER_PAY_BASES, PER_PAY_PROPOSALS, and PER_ALL_ASSIGNMENTS_F to derive salary analytics. It references HR_LOCATIONS_ALL for organizational context. The target PER_SALADMIN_ANALYTICS table holds both the analytics output and the refresh marker rows. Standard infrastructure objects include DUAL, PLITBLM (the PL/SQL index-by table type), and dictionary/elevation views DBA_EDITIONING_VIEWS and USER_SYNONYMS, the last two supporting 12.2 editioning compatibility checks.

Usage Notes

The package is normally invoked through the concurrent program that runs PER_SALADMIN_ANALYTICS_PROC, scheduled as part of the salary administration analytics refresh cycle. Because MESSAGE_LOG_PROC writes to fnd_file, output is visible in the request log of that concurrent program, making it the first place to inspect when diagnosing refresh failures. Custom code should call the public routines only, and should observe the CHECK_REFRESH_JOBS guard rather than attempting direct manipulation of PER_SALADMIN_ANALYTICS. No other documented packages reference this object, so its footprint is contained to the salary analytics refresh process.