SAP Knowledge Base Article - Public

3463573 - Integration center job not accepting value in preview from CSV upload.

Symptom

The customer trying to create an inbound integration job that upsert one-time payment records from SFTP to EmpPayCompNonRecurring entity.
However, the IC job show one value in preview and other value is missing. 

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
    • Integrations
      • Integration Center

Reproducing the Issue

1. Created an inbound Integration center job to upsert data from CSV to EmpPayCompNonRecurring .

2. Upsert CSV with the below data.

userIdnumberOfUnitsUOMpayComponentCodepayDatecurrencyCodeAmount
sfadmin2CountADDSAL_CL2023-05-17T00:00:00ZUSD0
sfadmin3CountADNT_HK_EE2023-05-16T00:00:00ZUSD0

3. In preview we can see below

Cause

This is expected behavior from system as Customers have added a Look UP table for the Field Paycomponent.

Resolution

It seems that you have added only one supported value to the Look Up Table, which is why you are seeing this issue.

Once remove the Lookup table you can see the correct data.

Keywords

EmpPayCompNonRecurring, Integration center, Missing, preview, CSV, SFTP, Import, Upsert, Value, Lookup, table, Field. , KBA , LOD-SF-INT-INC-JOB , Integration Center Job , LOD-SF-INT-INC , Integration Center , Problem

Product

SAP SuccessFactors HCM Suite 2405

Attachments

Pasted image.png
Pasted image.png
Pasted image.png
Pasted image.png
Pasted image.png
Pasted image.png