SAP / apibusinesshub-integration-recipes

Accelerate integration projects using SAP Cloud Platform Integration with crowdsourced best practices, curated by experts, designed for developers.
Apache License 2.0
112 stars 84 forks source link

SSN Field issue for "SAP SuccessFactors Employee Central Integration with Fidelity" #98

Open sgkulkarni opened 7 months ago

sgkulkarni commented 7 months ago

Describe the bug The iFlow produces an output which can have incorrect SSN values for the employees if the some of the employees in the selected dataset are having blank values coming from SF. If one of the employee has a blank SSN value then in the output the employee gets the next employee's SSN value assigned which potentially is a serious issue but as SSN is a key field for Fidelity it is less likely that this issue will happen in clean datasets of Pre-Prod/ Prod where every employee has valid SSN maintained. We noticed this issue in our Dev environment where test employees are not set up with full data set with valid SSN etc.

To Reproduce Steps to reproduce the behavior:

  1. Go to SuccessFactors and create 3 new hire records i.e. create 3 new employees
  2. Maintain the national id record with country usa and correct value for SSN field for the first and third employee record
  3. Do not maintain the national id record for second employee so that SSN stays blank. It is not mandatory field in SF.
  4. Configure the pre-build package "SAP SuccessFactors Employee Central Integration with Fidelity" for SF connections etc.
  5. Run the iFlow to get the output file
  6. The file will show correct SSN for first employee, Incorrect SSN for second employee (assigns third employee's SSN to second employee), Blank SSN for the third employee

Expected behavior Each employee must be assigned with correct SSN value from the employee data record from SF

Screenshots SF Data Employee 1234 SSN 123-45-6789 Employee 2345 SSN BLANK Employee 3456 SSN 234-56-7890

File Output for 02E (partial record): Plan SSN Record XXXX 123-45-6789 02E1234 XXXX 234-56-7890 02E2345 XXXX 02E3456

Expected Output: Plan SSN Record XXXX 123-45-6789 02E1234 XXXX 02E2345 XXXX 234-56-7890 02E3456

Desktop (please complete the following information):

Smartphone (please complete the following information):

Additional context Add any other context about the problem here. image