My Oracle Support Banner

Fusion Global Payroll: R11 Payroll Absences Processing Issue (Doc ID 2208647.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Fusion Global Payroll - Version and later
Oracle Fusion Global Payroll Cloud Service - Version and later
Information in this document applies to any platform.


Oracle has identified that a limited number of customer production environments have one or more Absence element formulas that could have an issue in Release 11. We have notified the impacted customers individually and created a service request. If you have not been contacted then you are not impacted. Due to this issue, a payroll run can potentially error or calculate and incorrect amount.

Problem Description
<AbsenceName>_ENT_CAL or DEBUG_ORA_ENTITLEMENT_CALCULATOR formula calls a utility formula “CALL_CALC_VALUE” to get hours for each absence day. This call was working earlier without setting the DATE_EARNED context. Setting this context has been made mandatory in R11.

This issue can impact in three ways:

1) Error during Calculate Payroll or Recalculate Payroll for Retroactive changes.  You may encounter an error like the following:
(ORACLE_ERROR_TEXT=)(FORMULA_ERROR_TEXT=Formula ORA_RATE_CALCULATOR, line 92, user-defined function error ORA-20001: The entry value is in an incorrect format. Details: The value entered (ENTRY_VALUE) is in an incorrect format for NONE unit of measure, as defined on the input value

2) Incorrect payroll run results
Absence formula can return -1 for ‘Absence Unit’, ‘Absence Factor’ etc. Then payroll run result will be a negative value, which is incorrect.

3) Incorrect retro element entries
Incorrect retro entries can get created when the Recalculate Payroll for Retroactive changes process recalculates the past periods and compares the incorrect results to original results.

Steps to check if absences was incorrectly calculated

1) From Navigator > Payroll Calculations > Submit a process, submit “Run Element Results Register” for a past period (select a period after R11 upgrade) for an Absence Payment element. Note that Absence Payment element will be an earnings element if you have followed <Note 1904188.1> or <Note 2102835.1>.  Filter the “Input Value Name” column in the excel output to “Hours” or “Hours Calculated”.

2) From the report output, pick couple of employees who have multiple days of absence.

3) Navigate to Person Management and search the absence records

4) Compare the units from Absence system (Step 3) to the output from Element Results Register (Step 1).

5) If there are differences, please log an SR describing the issue and mention this document. Oracle Development will work with you to identify all affected employees. Recalculate Payroll for Retroactive changes process will have to be run for the affected employees to fix the issue in past payroll periods. If the affected employee count is small, the retro events can be created using Manage Event Notifications UI. Otherwise, development will help in loading the retro event notifications through a script.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.