Not set value from Employee form(Collect Employee Form) to HR case

[abirakundu23]

Hi All/ @Sandeep Rajput ,

In our instance we have seen Employee Form collect input but those field value not populated correctly. It is not happening for every cases but some case we have see. 
If we see "asmt_assessment_instance" table and open the record and we see all value is there according to Employee form, however not populate few of the field mappings in HR cases.

What is the probable reason ?

[Sandeep Rajput]

@abirakundu23 Did you check the corresponding Employee form field mapping for these two fields? To me it appears that the mappings between the Survey questions and target table fields is not mapped correctly. Refer to https://www.servicenow.com/docs/bundle/yokohama-employee-service-management/page/product/human-resou... to know more about the steps to configure these mappings. 

[abirakundu23]

Hi @Sandeep Rajput ,
I have checked that fields are mapping correctly with survey form and target table , which it's not happening every time but few of the cases i have seen in PROD. I have tried in DEV it is working correctly, There is one more field Additional comments which is not working Dev instance as well but in assessment form additional comments saved,  What can be the issue ?
Please assist.

[Sandeep Rajput]

@abirakundu23 This look like a random issue associated with your instance. I recommend raising a ServiceNow support case to get this investigated further.

[abirakundu23]

Hi @Sandeep Rajput ,
Follow up questions regarding issue that mentioned.
In Product documentation, it is stating that employee form fields should be map to sn_hr_core_profile/sys_user table as part of OOB functionality and As per the documentation, the condition should be configured to return a single record:
“Use the condition builder to identify one record on the table to access. Make sure that the result is a match to a single record.”
https://www.servicenow.com/docs/bundle/yokohama-employee-service-management/page/product/human-resou...

But in  my business use cases target table is sn_hr_le_case/sn_hr_core_task and it's return more than single record as a result we are encounter issues where employee information not mapped correctly to the HR case fields as well and getting below error ,  attached screenshot as reference.

How can we mitigate this kind of issues ?