Search Results user_mmo_reason




Overview
Explore in AI Chat

Overview

APPS.HR_FR_MMO is a French (France) legislation payroll utility package body that resolves and processes absence reasons associated with the French "MMO" (Maintenance de Maintien de Salaire / absence reason) ruleset. Its primary business function is to determine, at runtime, which Oracle Fast Formula definition governs the calculation of an absence reason for a given employee assignment and effective date. The package encapsulates the lookup logic required to distinguish between a customer-specific formula and the Oracle-delivered seeded template, thereby preserving extensibility: legislations and business groups can override delivered behavior by defining their own formula while the package transparently falls back to the template when no override exists.

The package header comment identifies it as a French localized component (the "FR" in the name), originally shipped under the 11i-era file header hrfrmmo.pkb 120.0. It is classified as an OTHER API in ETRM, meaning it is not a public, supported interface but an internal payroll/dependency utility invoked by other Oracle objects rather than by end users directly. It is documented as being referenced by one other package, confirming that its role is to supply formula resolution and date/reason data to callers within the French payroll and absence processing flow.

Key Procedures and Functions

  • GET_FORMULA — Returns the formula identifier used for the MMO reason calculation. It first attempts to locate a user-defined formula named USER_MMO_REASON scoped to the caller's business group and effective on the session date. If no such row is found, it falls back to the Oracle-delivered template formula (TEMPLATE_MMO_REASON) for legislation FR. If neither exists, it signals an error condition.
  • GET_START_DATE — Derives the start date of the absence/reason period relevant to the MMO calculation, based on the assignment and effective dating context supplied by the caller.
  • GET_END_DATE — Derives the corresponding end date of the absence/reason period, complementing GET_START_DATE to bound the MMO processing window.
  • GET_REASON — Returns the absence reason value itself (the coded reason for the MMO event), presumably resolving the reason via the formula and assignment data obtained by the other functions.

The documented metadata specifies only names and purposes. Parameter lists are not published and should be treated as internal to the package; callers must not assume a stable signature.

Tables Accessed

  • FF_FORMULAS_F — The core Fast Formula definition table. GET_FORMULA queries it twice: once filtered by business group and formula name (USER_MMO_REASON), and once filtered by legislation code and formula name (TEMPLATE_MMO_REASON), with effective-date range predicates applied.
  • PER_ALL_ASSIGNMENTS_F — The assignment/employment datetable. Used to establish the employee assignment context and its effective dates for the MMO period calculations.
  • PER_ASSIGNMENT_STATUS_TYPES — Provides assignment status information needed to determine whether an assignment is active (and therefore in scope) for the absence reason and MMO processing.
  • PLITBLM — The PL/SQL table (index-by table) buffer log used for generic message/logging purposes, supporting error and diagnostic handling within the package.

Usage Notes

HR_FR_MMO is invoked internally by French localization payroll and absence processing logic, and is referenced by one other package. It is typically called at payroll run time or during absence evaluation, on Oracle EBS 12.1.1 and 12.2.2, where the effective session date drives formula version selection.

Because the ETRM classification is OTHER, the package is not a supported public API and should not be called directly from custom code. The correct mechanism for customer-specific MMO behavior is to define a Fast Formula named USER_MMO_REASON within the relevant business group; when present, it takes precedence over the delivered TEMPLATE_MMO_REASON formula. Failure to define either formula causes the package to raise an error, so implementers should verify formula configuration before enabling the MMO absence reason in a business group.