My Oracle Support Banner

Payroll Error For Employees That Are Working Beyond Normal Work Schedule: Formula ORA_PERIOD_WORK_SCHED_RATE, line 214, a number was divided by zero while executing the formula (Doc ID 2472149.1)

Last updated on APRIL 13, 2019

Applies to:

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

Symptoms

On : 11.13.18.05.0 version, Integration

When attempting to calculate Payroll,
the following error occurs:

ERROR
-----------------------
HR_51118_HRPROC_ERR_OCC_ON_ASG
HR_51119_HRPROC_ERR_OCC_ON_ET
HR_51120_HRPROC_ERR_OCC_ON_FML
HR_6867_HRPROC_FMLA_ORA_ERR
Formula ORA_PERIOD_WORK_SCHED_RATE, line 214, a number was divided by zero while executing the formula
PAY_PAYPROC_ERR_OCC_ON_CTFM

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. an employee works beyond his normal work schedule;
2. submitting the time sheet;
3. timesheet gets approved and transferred to Payroll successfully
4. calculate Payroll > Payroll is getting errored.

Details:
When an employee works beyond his normal work schedule and submit time sheet, payroll is getting error out.
The tested employee works Monday and Friday but in an emergency the employee worked for full week and submitted timesheet.
Timesheet gets approved and transferred to payroll successfully, but Payroll errored out.

Cause

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
Symptoms
Cause
Solution
References


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