SAP Knowledge Base Article - Public

2670361 - [Calculated Field] Field Filters are currently not working in Integration Center when used with "FOREACH"

Symptom

  1. You are using a calculated field in integration center which requires an input from a field which is under 1:M relation with the root entity
  2. You use field filter when navigating into the child entity

Environment

  • SuccessFactors
  • Integration Center

Reproducing the Issue

  • Use 1:M navigational field selection under FOREACH loop
  • When navigating from root entity to Child entity provide the field filter

Cause

The issue is happening because while the call is made to the underlying query engine which processes it, the navigational field which has the field filter is not read.

Resolution

Instead of using the field filter on the FOREACH loop, you can make use of If/The condition to fulfill the criteria.

The issue is put on the road map for 1811 and the same will be addressed.

Keywords

  • Field filters are not working when used with FOREACH
, KBA , field filters are currently not working , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , Bug Filed

Product

SAP SuccessFactors HCM Core all versions