SAP Knowledge Base Article - Public

3226011 - SIN not valid

Symptom

Saving SIN number for Employee located in Canada raises SIN not valid error.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Personnel Administration Workcenter
  2. Go to Employees view
  3. Edit the Employee 
  4. Go to Personal Data tab
  5. Enter Social Insurance Number
  6. Click Save

Error message 'SIN Entered is not valid' is raised.

Cause

The Social insurance number (SIN) is calculated using the Luhn algorithm.

Multiple the each digit of the number against the respective weight. If the product is greater than 9, then add the digits of the product. The sum of all the digits should be divisible by 10. 
Weight used is 121212121
if the product value is greater than 9, eg,. 15 then the value should be (1 + 5 = 6) 
eg.,
SIN      1 2 3 4 5 6 7 8 9 ,Disclaimer: The number is for reference purpose only.
weight  1 2 1 2 1 2 1 2 1
product 5 6 8 0 7 5 2 5 6
1 * 1 = 1
2 * 2 = 4
3 * 1 = 3
4 * 2 = 8
5 * 1 = 5
6 * 2 = 12 ( 1 + 2 = 3 ) 
7 * 1 = 7
8 * 2 = 16 ( 1 + 6 = 7 )
9 * 1 = 9
SUM  = 1 + 4 + 3 + 8 + 5 + 3 + 7 + 7 + 9 = 46
46 Mod 10 = 4, the sum is not divisible by 10.
Hence, 123-456-789 is an invalid SIN number.

If the SUM mod 10 is not equal to 0, then SIN number is invalid.

Resolution

Please enter the correct SIN nuumber.

See Also

Social Insurance Number, Canada, SIN not valid

Keywords

KBA , SRD-HR-PAD-CA , Canada , Problem

Product

SAP Business ByDesign 2022