Symptom
You created a calculated field in Integration Center job which uses a one-to-many navigation and it is bringing unexpected results in its calculation.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
- SAP SuccessFactors HCM Suite
- Integration Center
Reproducing the Issue
- Access Integration Center
- Select your integration and click on "Edit"
- Click on the field and "Edit Calculation", on calculation trace it is bringing proper data
- When looking at the preview of the field in "Configure Fields" tab or when running the integration, it is returning an unexpected data
Cause
One-to-many relationships may result in unexpected data.
Refer to KBA 3087941 - One-to-many behavior in Integration Center for an explanation on how to identify a one-to-many relationship and also about what causes this behavior when using it.
Resolution
In order to fix the issue you need to make sure that the one-to-many relationship will bring only one of the many values. You can do that by using the "Field Filters" by following these steps:
- "Edit Calculation" of your calculated field:
- Click in the button with "3 lines" and after that in "Associate Field":
- Go to "Field Filters" at the bottom and define the values that you are trying to find.
In this example above, we selected the payGroup=='MTH' and payComponent=='PersonBasePayAmount'.
These selections will force the system to bring the values of these records in the calculated field and it will avoid bringing values of other payGroup or payComponent that could have been considered before.
The point here is to make the Field Filter always return just one of the many values that are considered in the one-to-many relationship.
See Also
Keywords
SuccessFactors Integration Center (IC), Calculated field, Incorrect calculation, Incorrect data, one-to-many, one to many, 1:M , KBA , LOD-SF-INT-INC-FWK , Integration Center UI Framework , How To