Search Results refresh_person_info




Overview
Explore in AI Chat

Overview

APPS.BEN_CWB_PERSON_INFO_PKG is a Compensation Workbench (CWB) support package in Oracle E-Business Suite Advanced Benefits. It supplies the derived person-level information that Compensation Workbench relies on when presenting salary, grade, and comparative analysis data to managers and compensation administrators. The package consolidates assignment salary details, payroll pay-basis conversions, grade range statistics, length-of-service calculations, and salary survey benchmarks into a single programmatic interface.

The user search term "refresh_person_info" corresponds directly to the package's central procedure, REFRESH_PERSON_INFO, which populates and maintains the CWB person information cache. In EBS 12.1.1 and 12.2.2 the package is owned by APPS and classified as OTHER in the ETRM repository, indicating it is an internal utility rather than a published public API. Its header comment references version 120.13, consistent across both release levels.

Key Procedures and Functions

The package exposes sixteen documented procedures and functions. Fourteen of these are described below; the remaining public entries are internal helpers surfaced in the ETRM listing.

  • REFRESH_PERSON_INFO — The primary entry point. Rebuilds the person-level compensation records used by Compensation Workbench, drawing salary, grade, and service data for the target person or assignment population.
  • REFRESH_PERSON_INFO_GROUP_PL — A group variant of the refresh routine, intended for processing a population or group of persons in a batch-oriented or parallel manner.
  • REFRESH_FROM_MASTER — Refreshes person information by referencing master or source data, used when downstream caches must be synchronized with authoritative records.
  • GET_YEARS_IN_JOB, GET_YEARS_IN_POSITION, GET_YEARS_IN_GRADE — Compute tenure in the employee's current job, position, and grade respectively, supporting service-based eligibility and compensation rules.
  • GET_GRD_MIN_VAL, GET_GRD_MAX_VAL, GET_GRD_MID_POINT — Return the minimum, maximum, and midpoint values of the applicable grade rate range.
  • GET_GRD_QUARTILE, GET_GRD_QUINTILE, GET_GRD_DECILE — Determine the employee's position within the grade range expressed as quartile, quintile, or decile bands.
  • GET_GRD_COMPARATIO — Calculates the compa-ratio, the relationship of actual salary to the grade midpoint.
  • GET_GRD_PCT_IN_RANGE — Computes the percentage penetration of salary through the grade range.
  • GET_SALARY_CURRENCY — Derives the currency associated with the assignment's pay basis or input value.
  • GET_FTE_FACTOR — Returns the full-time-equivalent factor used to normalize salaries, governed by the BEN_CWB_FTE_FACTOR profile option.

Tables Accessed

The package reads and writes the CWB person information cache table BEN_CWB_PERSON_INFO, along with CWB configuration tables BEN_CWB_PL_DSGN and BEN_PL_EXTRA_INFO. Historical eligibility data is drawn from BEN_PER_IN_LER. Assignment, salary proposal, and pay-basis data come from PER_ALL_ASSIGNMENTS_F, PER_PAY_BASES, PER_ALL_PEOPLE_F, PER_APPRAISALS, and PER_EVENTS.

Payroll configuration is sourced from PAY_ALL_PAYROLLS_F, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, PAY_PEOPLE_GROUPS, and PAY_GRADE_RULES_F, the latter supplying the grade range values used by the minimum, maximum, and midpoint functions. HR_ORGANIZATION_INFORMATION provides organizational attributes for grouping purposes.

Usage Notes

REFRESH_PERSON_INFO and its group counterpart are typically invoked during the Compensation Workbench setup and maintenance cycle, ensuring that managers see current salary, grade progression, and comparative statistics when entering compensation proposals. The grade analytics functions and tenure calculations are called on demand when rendering CWB worksheet lines or planning detail pages.

Because the package is classified as OTHER and ETRM lists nine dependent packages, it should be treated as an internal dependency rather than a supported public API. Customizations should avoid direct calls to REFRESH_PERSON_INFO; instead, run the standard Compensation Workbench concurrent programs that invoke it. The profile option BEN_CWB_FTE_FACTOR must be configured before refresh execution, as it influences every FTE-adjusted salary calculation in the package.