GP UK - Amended P60 Report Requires Employee To Have A National Insurance Number
Last updated on MAY 02, 2018
Applies to:PeopleSoft Enterprise HCM Global Payroll UK - Version 9.2 and later
Information in this document applies to any platform.
The Amended P60 report does not pick employees if they don't have an NI number, or their NI number is not 9 characters.
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'
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