Search Results pay_fr_sickness_absence




Overview
Explore in AI Chat

Overview

APPS.PAY_FR_SICKNESS_ABSENCE is a PL/SQL package in the Oracle E-Business Suite APPS schema that implements French statutory sickness absence processing within Oracle Payroll. Its purpose is to bridge the Oracle Human Resources absence framework and the Oracle Payroll element entry mechanism so that employee sickness records in France generate the correct payroll costing and absence element entries automatically. The package is classified as a non-public (OTHER classification) API, meaning it is intended for internal use by Oracle-published code rather than as a supported customer-facing interface. It is a VALID object in both EBS 12.1.1 and 12.2.2, and is referenced by the absence business logic packages HR_PERSON_ABSENCE_BK1 and HR_PERSON_ABSENCE_BK2, which invoke its logic as part of the standard absence create, update, and delete lifecycle.

Key Procedures and Functions

The ETRM metadata documents seven entry points within the package, covering the core absence and payroll entry operations:

  • PERSON_ABSENCE_CREATE — Creates the absence attendance record logic required when a French sickness absence is registered, working against the PER_ABSENCE_ATTENDANCES structures.
  • PERSON_ABSENCE_UPDATE — Handles the update path for an existing sickness absence record, including date or duration changes.
  • PERSON_ENTRY_CREATE — Creates the corresponding payroll element entry (PAY_ELEMENT_ENTRIES_F) associated with the absence so that the absence is costed and processed by payroll.
  • PERSON_ENTRY_UPDATE — Updates the existing payroll element entry when the underlying absence changes.
  • CHECK_ADD_ABS_ENT_CREATE — Validates whether an absence element entry should and can be created, acting as a control check before the create logic executes.
  • CHECK_ADD_ABS_ENT_UPDATE — Performs the equivalent validation for the update path.
  • CHK_TRG_CATG_HRS — Checks the triggering absence category and hours, supporting the rules that determine how French sickness absence entitlement and element generation are triggered.

No parameter signatures are documented in the ETRM extract, and these should be confirmed by reading the package specification in the database rather than assumed.

Tables Accessed

The package operates across both HR and Payroll data model objects, referenced through APPS synonyms:

  • PER_ABSENCE_ATTENDANCES and PER_ABSENCE_ATTENDANCE_TYPES — the primary HR absence records and their types, used to create, update, and validate sickness absences.
  • PER_ALL_ASSIGNMENTS_F and PER_PERIODS_OF_SERVICE — used to resolve the employee assignment and service context for the absence.
  • PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_ENTRY_VALUES_F — the payroll element entry and value records generated or amended for the absence.
  • PAY_ACCRUAL_PLANS — referenced for accrual plan linkage relating to absence entitlement.
  • FF_GLOBALS_F — Fast Formula globals read during validation and calculation logic.
  • DUAL — used for simple singleton queries.

Usage Notes

Because PAY_FR_SICKNESS_ABSENCE is referenced by HR_PERSON_ABSENCE_BK1 and HR_PERSON_ABSENCE_BK2, it is invoked indirectly whenever a French sickness absence is entered, amended, or deleted through the Oracle HRMS absence forms. It should not generally be called directly; Oracle does not publish it as a supported API. Customisations that need to replicate or extend the behaviour should call the supported absence APIs, which in turn trigger this package. When diagnosing absence-to-payroll issues in a French installation, this package is a key point to inspect, since it is the layer that converts an HR absence into a payroll element entry. That element entry must exist and be valid before the payroll run will process the absence correctly.