Transform map Workday

[Ashutosh4]

hello All, 

I am doing workday Integration and pulling the data into HR profile staging table and it is coming correctly,

then I have an OOTB transfrom map from HR profile staging to HR profile table.

But when the data loads in the staging table , it doenst have the target record or target table and it gets into Pending state. 

What is causing the issue ? 

Bit urgent, can any one please help ?

[Ashutosh4]

Also one more thing, this works perfectly fine in dev instance, but in test i have been seeing this issue, once in a while it does take the target record too, but no consistency

[abirakundu23]

Hi @Ashutosh4 ,

Please follow below steps for troubleshooting: 
1. Import Set Stuck: 

Check Import Sets list (sys_import_set.list) and find any older records in the Loading state. If import set is stuck "Loading," ServiceNow won't trigger the transform for new ones. Manually change their state to Processed or Cancelled. 

 2.  Access /User permission: 

Compare the User account used for the Workday integration in Dev vs. Test. Cross check Test user has sn_hr_core.admin, import_set_loader, and import_transformer.  If the user doesn't have permission to write to the HR Profile table, the transform will never start.  

 3. Import set Trigger: 

Check the configuration of Scheduled Data Import (the records pulls from Workday) and the trigger condition. 
4. Cross-ScopeAccess: 

 If any records with a status of "Denied" involving the HR staging table or the sn_hr_core_profile table please fix "Denied" to "Allowed."

I have mentioned the above steps, after checking if you observe issue still persists as OOB configuration you can check with HI team as well if you follow entirely OOB configuration. 

Please mark helpful and correct answer if it's worthy for you.