Symptom
Saving SIN number for Employee located in Canada raises SIN not valid error.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Personnel Administration Workcenter
- Go to Employees view
- Edit the Employee
- Go to Personal Data tab
- Enter Social Insurance Number
- 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