GP UK - Amended P60 Report Requires Employee To Have A National Insurance Number (Doc ID 2129889.1)

Last updated on APRIL 22, 2016

Applies to:

PeopleSoft Enterprise HCM Global Payroll UK - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

The Amended P60 report does not pick employees if they don't have an NI number, or their NI number is not 9 characters.

Replication steps
==============
1. Find an employee who doesn't have an NI number
2. Find another employee who has an 8 digit NI number (National ID Type is "PR" ("National Insurance Number", not "Nat Ins Num (9 Chars)")
3. Enter an adjustment on the page for both employees Global Payroll & Absence Mgmt > Payee Data > Taxes > RTI Adjustment Details GBR
4. Run the Amended P60 report - it will not identify either employee

The problem is in SQR gpgbp60a.sqr (procedure P60-Select-Employees_RTI). The WHERE clause of the SQL select in this procedure has the following join where "A" is GPGB_RTI_ADJ and "B" is PERS_NID):

AND A.EMPLID=B.EMPLID AND B.NATIONAL_ID_TYPE='PR_9' AND B.COUNTRY='GBR' AND B.PRIMARY_NID='Y'

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms