In Integration Center, one or more fields show correct value in preview but delivers wrong value in the output file (Run now).
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
- SAP SuccessFactors HXM Suite
- Integration Center
Reproducing the Issue
- Create an Integration in Integration Center.
- Include Date type fields in the integration or a date field for calculation of any field or other calculated field with different kinds too.
- Save and Run the integration.
- You will notice correct value in "Configure Fields" tab or Preview but wrong value in Output File for the fields having Date Comparisons or One to Many.
If you have Calculated fields with dates comparison:
- The issue happens when we are not using datetime field type while doing the calculation. Like instead of 09/01/2020 we have to give 2020-09-01T00:00:00Z and then compare with the Date Field.
Other possibility of the issue would be if you have calculated fields with One to Many navigations (parent/child entities).
Calculated fields with Date comparison:
- Make sure the Date fields being compared are in the same format. Note: in calculated fields, you cannot use custom dates for date comparison (different datatype comparison is not allowed in calculated fields. All the fields must be of the same datatype while performing a comparison. Currently there is no workaround for this: If you want to use DateTime as a data type of the calculated field, then you will have to ensure that all the fields are of DateTime data type.
- Note: The datetime field comparison will work in preview even with value 09/01/2020 but will not work at the run time due to incorrect field type. Hence we need to change the value from 09/01/2020 to 2020-09-28T00:00:00Z .
Calculated fields with One to Many navigations:
- Check the details of the KBA 2528579 - “Calculated field” is not calculating correctly for few data - SuccessFactors Integration Center
Integration Center Preview, Integration Center Output, Configure Fields, Calculation, Date Field, Date Format, One to Many, IC, Run NOW, DateTime, data type, calculated field, preview, calculated, Integration Center, , KBA , LOD-SF-INT-INC-FWK , Integration Center UI Framework , How To