Search Results per_saladmin_analytics_proc

Overview

APPS.PER_SALADMIN_ANALYTICS_PKG is a PL/SQL package body in Oracle E-Business Suite that supports the Salary Administration analytics feature. Its principal role is to populate and refresh the PER_SALADMIN_ANALYTICS table, which stores summarized compensation metrics used for salary administration reporting and analysis. The package body is versioned at 120.3 (last modified 2012/01/04) and is classified under the OTHER API classification, meaning it is an internal implementation package rather than a published or supported public API.

The package computes aggregated headcount and salary statistics — including median salary, comparatio, and range position — across job, country, and pay basis dimensions. These derived values enable HR and compensation administrators to compare employee salaries against grade structures and organizational benchmarks.

Key Procedures and Functions

• PER_SALADMIN_ANALYTICS_PROC — The main driver procedure and the object most commonly referenced by the search term "per_saladmin_analytics_proc." It accepts standard concurrent program OUT parameters (ERRBUF and RETCODE) and performs the core analytics computation. It declares a bulk-collect type based on PER_SALADMIN_ANALYTICS%ROWTYPE and uses a cursor (SALANALYTICS) that aggregates headcount via SUM, median salary via PERCENTILE_CONT, comparatio as a percentage of grade midpoint, and range position as a percentage within the grade min/max band. Effective end dates are extended to HR_GENERAL.END_OF_TIME when the effective start date is the current date.
• MESSAGE_LOG_PROC — Provides logging of processing messages, supporting diagnostic and error reporting during analytics runs.
• CHECK_REFRESH_JOBS — A function returning a NUMBER that queries PER_SALADMIN_ANALYTICS for a sentinel row where JOB_ID and PAY_BASIS_ID both equal -2. It returns 1 if such a row exists and 0 on NO_DATA_FOUND, effectively indicating whether a refresh is currently in progress.
• INSERT_REFRESH_JOBS — Inserts the sentinel row (-2, -2) into PER_SALADMIN_ANALYTICS to signal that a refresh job is active. Declared with PRAGMA AUTONOMOUS_TRANSACTION so the marker commits independently of the caller's transaction.
• DELETE_REFRESH_JOBS — Removes the sentinel row, clearing the refresh-in-progress indicator. Also declared with PRAGMA AUTONOMOUS_TRANSACTION to commit independently.

Tables Accessed

• PER_SALADMIN_ANALYTICS — The primary target table, both read (CHECK_REFRESH_JOBS) and written (INSERT/DELETE_REFRESH_JOBS and the main procedure's aggregated results).
• PER_ALL_ASSIGNMENTS_F — Source of assignment-level salary and grade data.
• PER_PAY_BASES and PER_PAY_PROPOSALS — Supply pay basis and salary proposal information used in the analytics calculations.
• PAY_ELEMENT_TYPES_F, PAY_GRADE_RULES_F, and PAY_INPUT_VALUES_F — Provide pay element, grade rule, and input value definitions underpinning grade min/max and midpoint values.
• HR_LOCATIONS_ALL — Supplies location attributes for geographic analysis.
• DUAL, PLITBLM, DBA_EDITIONING_VIEWS, and USER_SYNONYMS — Utility and metadata references used for control-flow and editioning checks.

Usage Notes

PER_SALADMIN_ANALYTICS_PKG is typically invoked through a concurrent program submitted from the Salary Administration responsibility, or scheduled as a recurring refresh job. The main procedure follows the standard concurrent program interface, returning ERRBUF and RETCODE to the Concurrent Manager.

The autonomous-transaction refresh-marker procedures (CHECK_REFRESH_JOBS, INSERT_REFRESH_JOBS, DELETE_REFRESH_JOBS) implement a simple concurrency guard preventing overlapping refresh executions. The package is referenced by no other packages in the ETRM metadata, indicating it is a top-level entry point rather than a shared utility. Customizations should avoid direct calls, as the package is classified as OTHER and unsupported for extension.