In case of Terminated Employee, the Field "Class1ANICsYTD" on FPS is Acting as PTD rather than YTD if Off Cycle and On Cycle Payroll Are Run in the Same Calendar Period (Doc ID 2889241.1)

Last updated on AUGUST 16, 2022

Applies to:

Symptoms

An Off-cycle calendar was created for a terminated employee on Class 1A NICs amounts before the On-cycle calendar period was generated. 
This employee should have been terminated in the prior calendar period. The Off-cycle calendar captured the employee' Termination Information, including the "LeavingDate" on FPS. 
Along with the Termination information, the "Class1ANICsYTD" was included in this Off-cycle FPS.

When the On-cycle Payroll for the current calendar period was generated, this employee had a Payroll generated but with no earnings or deductions and no accumulators.
In the FPS report generated for the On-cycle, the Gross YTD, Taxable/Tax YTD, etc. were on the RTI file but the "Class1ANICsYTD" was not. 
It appears that the YTDs are being rolled forward in table PS_GPGB_FPS_SUBMIT for the On-cycle. 
However, "Class1ANICsYTD" has zero value on the On-cycle in PS_GPGB_FPS_SUBMIT and therefore the value is not appearing on the On-cycle FPS.

The Off-cycle Payroll and On-cycle Payroll were in the same calendar period and the On-cycle FPS replaces the prior Off-cycle FPS.  
Since the field "Class1ANICsYTD" value is zero in the On-cycle Payroll, this zeroes out the balance at HMRC.
The FPS results from the On-cycle Payroll should not replace the Off-cycle Payroll results.

 Steps to replicate the issue:

1. Add a Termination row prior to the current calendar period. For example, current calendar period = August 16th, 2022, the termination row should be prior to this calendar period.
Navigation: Workforce Administration > Job Information > Job Data

2. Calculate and Finalize the Off-cycle calendar.
Navigation: Global Payroll & Absence Mgmt > Absence and Payroll Processing > Off Cycle > Off Cycle On Demand > Off Cycle On Demand

3. Check the Off-cycle calendar results and observe that the accumulator which feeds "Class1ANICsYTD" on FPS, GBR NI ER TERM YTD, is listed for the correct amount.
Navigation: Global Payroll & Absence Mgmt > Absence and Payroll Processing > Review Absence/Payroll Info > Results by Calendar > Earnings and Deductions

4. Review the FPS results for the Off-cycle calendar.
Navigation: Global Payroll & Absence Mgmt > Absence and Payroll Processing > Report and RTI Preparation GBR > Report and RTI Preparation GBR

5. Identify and Calculate the On-cycle calendar. The employee was calculated in the On-cycle, including the employee's termination, prior to Payroll Begin Date.
Navigation: Global Payroll & Absence Mgmt > Absence and Payroll Processing > Calculate Absence and Payroll > Calculate Absence and Payroll

6. Review the On-cycle calendar results - a blank Payroll was generated with no earnings, deductions, accumulators, etc.
Navigation: Global Payroll & Absence Mgmt > Absence and Payroll Processing > Review Absence/Payroll Info > Results by Calendar > Earnings and Deductions

7. Check the FPS results for the On-cycle calendar and observe that the "Class1ANICsYTD" is not present.
Navigation: Global Payroll & Absence Mgmt > Absence and Payroll Processing > Report and RTI Preparation GBR > Report and RTI Preparation GBR 

Changes

Cause

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