My Oracle Support Banner

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

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.

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):



To view full details, 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 a vibrant support community of peers and Oracle experts.