Wrong Value for Benefits Taxed Year To Date (YTD) Is Displayed on the RTI FPS Run Reconciliation Report After Running RTI - Full Payment Submission Process (FPS) 2023/24 Concurrent Program (Doc ID 3006774.1)

Last updated on MARCH 01, 2024

Applies to:

Symptoms

After running RTI - Full Payment Submission Process (FPS) 2023/24 concurrent program, when checking the RTI FPS Run Reconciliation Report (RTI: Real Time Information) it has been observed that the value for Benefits Taxed Year To Date (YTD) is wrong for employee with NI Multiple Assignments (NI: National Insurance) on different payroll period types (weekly and monthly)

The issue can be reproduced at will with the following steps:

  1. Under UK HRMS Manager responsibility or equivalent.

  2. Navigate to People > Enter and Maintain > Query for employee with NI Multiple Assignments on different payroll period types (weekly and monthly).

  3. Assignment > Query for the NI Reporting Assignment (primary assignment having monthly payroll attached) > Entries.

  4. Add 'GB BIK Car and Car Fuel' seeded element starting with the current payroll period and with a benefit end date set to the last day of current fiscal year (05-APR-2024).

  5. Navigate to Processes and Reports > Submit Processes and Reports > Single Request > Run the following for the NI Reporting Assignment payroll:
     5a) Payroll Run UK concurrent program.
     5b) PrePayments concurrent program.
     5c) RTI - Full Payment Submission Process (FPS) 2023/24 concurrent program (using the Prepayment request id from step 5b).
     5d) RTI FPS Run Reconciliation Report process is automatically spawned by the RTI - Full Payment Submission Process (FPS) 2023/24 concurrent program.

  6. Navigate to View > Assignment Process Results > Query for the NI Reporting Assignment > Select the Payroll Run row (from step 5a) > click on SOE Report > Observe the following Message: "The taxable value of (GB BIK Car and Car Fuel) is 100.00 ...".

  7. Navigate to Processes and Reports > View Requests > Query for the RTI FPS Run Reconciliation Report process (from step 5d) > Click on View Output > Observe the same value: Benefits Taxed Year To Date (YTD): 100.00 .

  8. Navigate to Processes and Reports > Submit Processes and Reports > Single Request > Run the following for the Non-NI Reporting Assignment payroll (secondary assignment having weekly payroll attached):
     7a) Payroll Run UK concurrent program.
     7b) PrePayments concurrent program.
     7c) RTI - Full Payment Submission Process (FPS) 2023/24 concurrent program (using the Prepayment request id from step 7b).
     7d) RTI FPS Run Reconciliation Report process is automatically spawned by the RTI - Full Payment Submission Process (FPS) 2023/24 concurrent program.

  9. Navigate to View > Assignment Process Results > Query for the Non-NI Reporting Assignment > Select the Payroll Run row (from step 7a) > click on SOE Report > Observe no relevant message.

  10. Navigate to Processes and Reports > View Requests > Query for the RTI FPS Run Reconciliation Report process (from step 7d) > Click on View Output.

  11. Observe the following wrong value (displayed under both NI Reporting Assignment and the Report Totals section) in the FPS Reconciliation Report:
     -> Benefits Taxed Year To Date (YTD): 0.00.

Cause

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