3423425 - Employee with incorrect User Type or Extension status is not being sync in IAS integrations - Onboarding

• Scenario 1:
  • An IAS integration for a SAP application is not receiving the candidate's data because, in the table 'Table_USER_ACCOUNT" (Data Inspector), the User Type is 'onboardee', but it should be 'employee'.
  • The user status in Table_USERS_SYSINFO  is 't'.
  • The candidate was purged. 
• Scenario 2:
  • An IAS integration for a SAP application is not receiving the candidate's data because, in the table 'Table_USER_ACCOUNT" (Data Inspector), the Extension status is equals to "2"(Pending), but it should be '0'.
  • The user status in Table_USERS_SYSINFO  is 't'.
  • After making the wrong choice regarding the rehire method, the candidates were purged and then rehired.

SAP SuccessFactors Onboarding

Scenario 1: 

1. Go to Data Inspector 
2. Select the table 'Table_USER_ACCOUNT'
3. Search for the Employee's username 
4. See the User Type as "Onboardee"
5. See the Extension status as "2" indicating pending tasks in Onboarding end
6. Go to Data Inspector
7. Select the table "Table_USERS_SYSINFO" 
8. Search for the username 
9. See the User Status as "t" indicating that is no more a candidate

Scenario 2: 

1. Go to Data Inspector 
2. Select the table 'Table_USER_ACCOUNT'
3. Search for the Employee's username 
4. See the User Type as "Employee"
5. See the Extension status as "2" indicating pending tasks in Onboarding end
6. Go to Data Inspector
7. Select the table "Table_USERS_SYSINFO" 
8. Search for the username 
9. See the User Status as "t" indicating that is no more a candidate

If the candidate was purged before to complete all tasks, the job that is supposed to convert the candidates into employees cannot run, and the conversion does not happen. 

The Data Inspector > Table_USER_ACCOUNT > Extension status, it is indicated as '2'. This value means that there is one or more pending Onboarding tasks for this candidate.

A script is necessary to correct the data. Please raise an incident to support

Support Engineers: See internal notes

Onboarding, obx, table, Table_USER_ACCOUNT, Table_USERS_SYSINFO, status, type, onboardee, employee, 2, hire, candidate, converted , KBA , LOD-SF-OBX-IAS , IAS User Authentication , Problem