SAP Knowledge Base Article - Public

3049287 - Integration Center : Blank value displays for an Input Value which is not maintained in VLT

Symptom

In Integration Center, You are using a Value LookUp Table on a field. The field has N number of Input - Output pair defined in the VLT but while running the Integration you come across more Input values than these N values defined which in turn show Blank value in Output.

   

"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 HXM Suite
    • Integration Center

Reproducing the Issue

  1. Create an Integration in INC.
  2. Use a Value LookUp Table on a field, say Employee Status.
  3. Define 5 values of Employee Status in VLT.
  4. Run the Integration Job.
  5. You will notice the Employee Status is returned as BLANK.
  6. On investigating further, you will notice the Employee Status returned blank corresponds to 6th Input Value - Unpaid Leave, which is not defined in the VLT.


Cause

Expected Behavior.

In the final output the input value matching output value is picked and returned.

If the value is not present in VLT it gives blank in output.

Resolution

For every value we get from the DB field the corresponding input and output value should be present in VLT.

Maintain all possible Input - Output Pair values in the VLT or else a blank value will be returned.

Keywords

Value Look Up Table, VLT, Integration Center, VLT returning Blank Value, INC field not returning data , KBA , LOD-SF-INT-INC , Integration Center , Problem

Product

SAP SuccessFactors HXM Suite 2111