My Oracle Support Banner

GPES: Incorrect BRD Calculation In Case of Employee With Social Security Base With Maximum Amount in 31 Days Amount (Doc ID 2815412.1)

Last updated on JULY 18, 2022

Applies to:

PeopleSoft Enterprise HCM Global Payroll Spain - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When an employee is in absence, we need to retrieve bases from previous months, to calculate the BRD (daily regulatory base) that is used to calculate both bases and subsidies.
Depending of the type of employee (full time or part time) and the absence type, we need to retrieve 1 month back or 3 months back or 12 months backs.

Additionally, for the CP base calculation, we need to retrieve the average of the last 12 months overtime.
This is calculated during payroll calculation.

For full time monthly employees, BRD, daily regulatory base is calculated as sum of the previous base/contributing days in the previous month.
For full time daily employees BRD is calculated as previous bases/natural days in the previous month.

Then we calculate the SUBSIDY, multiplying the BRD by the number of days in absence eligible for the subsidy.
They are counted as natural.

Consider for e.g. a monthly employee with social security base with maximum amount 4.070,1 Euros which starts Maternity on 30th of May, then the system should calculate BRD as follows: Base of April / contributing days in April = 4070,1/30 = 135,67 Euros
Then subsidy should be calculated as follows: 135,67*2 days of absence = 271,34 Euros

Correct Calculation:
System should calculate BRD as follows:

Base of April / contributing days in April = 4070,1/30 = 135,67 Euros ->  then it applies a ceiling -> 4070,1/31=131,29

It divides it using 31 days, because the current month (May) has 31 days.

This is done in the formula SS FM LIM BRD AUS which applies a ceiling calculated in formula SS FM BS MNSUAL.

Steps to replicate the issue:

Prerequisite for testing: Use a monthly employee with high salary (check by navigating to Workforce Administration > Job Information > Job Data : Compensation Tab 
   1. Navigate to Global Payroll & Absence Mgmt > Absence and Payroll Processing > Calculate Absence and Payroll : Run November 2019 Payroll
   2. Navigate to Global Payroll & Absence Mgmt > Payee data > Maintain Absences >Absence Event ESPs (Enter Sickness - IT absence take) from 16-DEC-19
   3. Navigate to Global Payroll & Absence Mgmt > Absence and Payroll Processing > Calculate Absence and Payroll : Run December 2019 Payroll
   4. Navigate to Global Payroll & Absence Mgmt > Absence and Payroll Processing > Results by Calendar Group - Earnings and Deductions Tab : Check the value for SUBSIDIO IT

Observe: Subsidio IT is not calculated correctly for a full time employee

Changes

 Issue encountered after applying PUM Image 33.

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
Changes
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.