My Oracle Support Banner

System does not allow SSN that begins with 9, issued by US-IRS, for Canadian Employees (Doc ID 2097200.1)

Last updated on NOVEMBER 24, 2019

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 8.8 SP1 and later
PeopleSoft Enterprise CS Campus Community - Version 9 to 9 [Release 9]
Information in this document applies to any platform.


When attempting to add a special national ID issued by the United States (US) Internal Revenue Service (IRS) for Canadian employees to share in profits of a US company, the following occurs:
Social Security Number cannot begin with 9. (1000,2282)
There are specific restrictions for formatting Social Security Number. Reenter the Social Security Number which is not having 900-999 in 1 to 3 Positions.

If the same number is entered as a Canadian SIN, then it generates the following message:


The format of the National ID Type PR for country CAN has to be 999-999-999. (1000,490)
The format of the National ID has to be set as indicated for this National ID Type.


Nor is it possible to create a new NID Type for USA or CAN. The system issues message that the country already exists, and apparently you cannot enter two NID types for the same country.

As a result of these edits, when a Canadian employee working for a US company has been issued a valid national ID from US-IRS that begins with '9', we cannot save the correct SSN in PeopleSoft system.


1. Go to Modify a Person and open the employee record.
2. Click [+] on the NID section to add a National ID.
3. Enter type USA and an NID that starts with '9'. Error is generated and the record cannot be saved.
4. Enter type CAN and an NID that is formatted like SSN. Error is generated that the format is not correct for SIN.
5. Try to add a new NID type for USA or CAN country, and the system does not allow two NID types for the same country.


To view full details, sign in with your My Oracle Support account.

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

In this Document

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