Search Results check_source

Overview

APPS.PAY_HK_MPF is an Oracle E-Business Suite payroll package body that implements Hong Kong Mandatory Provident Fund (MPF) statutory calculations for the Oracle HRMS Payroll application. It is classified in the ETRM repository as an OTHER API object, meaning it is not a formally certified public API but is nonetheless a load-bearing component of the Hong Kong localisation. In release 12.1.1 and 12.2.2 it is invoked from payroll formula functions and fast-formula contexts to determine retroactive MPF contributions, validate MPF scheme eligibility, determine qualifying quarter counts, and derive actual termination dates for MPF purposes. The package encapsulates the jurisdiction-specific rules that distinguish Hong Kong payroll processing from the generic Oracle payroll engine: age-based eligibility windows, employee versus employer contribution percentages, minimum and maximum relevant income thresholds, and proration across part periods.

Key Procedures and Functions

• GET_RETRO_MPF — Returns a numeric retroactive MPF contribution amount. It works from the assignment, business group, calculation dates, pay basis, contribution percentage, calculation method, hire date, minimum birthday, employer liability start date, employee deduction start date and contributions end date. Internally it drives a cursor over pay_hk_mpf_ri_balances_v joined to per_time_periods, matching the MPF_RI balance across prior payroll periods, ordering by period start date and descending action sequence, and accumulating capped and prorated relevant income. The ETRM excerpt shows explicit handling for the 65th birthday (derived via ADD_MONTHS(p_min_birthday, 564)) and for employees commencing after 1 February 2003 who reach age 18 on or after 18 January 2008.
• HK_SCHEME_VAL — Validates an MPF scheme for the assignment, confirming that the scheme selected is one the employee is eligible to participate in under Hong Kong MPF rules.
• HK_QUARTERS_VAL — Determines the number of qualifying MPF quarters, used where contribution or eligibility tests are expressed in quarterly units.
• GET_ACT_TERMINATION_DATE — Returns the actual termination date used for MPF purposes, which may differ from the HR termination date recorded on the assignment or period of service.

Tables Accessed

• PER_ALL_ASSIGNMENTS_F — supplies assignment, business group, payroll and date-tracked context.
• PER_TIME_PERIODS — defines payroll period boundaries used to place each retroactive balance in the correct period.
• PER_PERIODS_OF_SERVICE — provides hire and termination dates for eligibility and termination-date derivation.
• HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION — resolve the employing organisation and its MPF-related classification information.
• PER_ASSIGNMENT_EXTRA_INFO — holds assignment-level MPF attributes such as scheme selection.

Usage Notes

The package is not referenced by any other documented package in the ETRM repository, indicating that it is called directly from Oracle Payroll formulas (fast formulas) and possibly from custom payroll processes or concurrent programs rather than from a PL/SQL call hierarchy. The user search term check_source relates to inspecting the source declaration of PAY_HK_MPF to confirm the available entry points before configuring a formula. When troubleshooting Hong Kong MPF results in 12.1.1 or 12.2.2, the source header should be verified, since the documented header (pyhkudfs.pkb 120.2.12010000.3) identifies a specific 2008 fix level, and later patches may amend the retro, birthday and eligibility logic shown in the excerpt.