Last updated on DECEMBER 05, 2016
Applies to:Oracle Fusion Global Payroll - Version 184.108.40.206.0 and later
Oracle Fusion Global Payroll Cloud Service - Version 220.127.116.11.0 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.
<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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms