SAP Knowledge Base Article - Public

3735580 - Integration center export shows 31.12 birthdates with +1 year while preview is correct.

Symptom

  • The integration center job sends correct birthdates for employees in the diagnostics file in json format
  • However the sftp adds 1 year for those born on 31.12
  • The issue occurs only for employees with birthdates on 31.12.; other dates are processed correctly.
  • No error messages are displayed.

Environment

  • SAP SuccessFactors Platform
  • Integration Center

Reproducing the Issue

  1. Login to the affected Integration Center job.
  2. Change the filter to include at least one user with birthdate 31.12 and one user with a different birthdate for comparison.
  3. Configure the job to deliver the output file to an SFTP location with access for analysis.
  4. Run the integration and review the generated file on SFTP, comparing the birthdate values with the preview.
  5. The birthdate is incorrect and incremented by one year

Cause

  • The incorrect date format is maintained in integration center

Resolution

    1. Verify the date format required by the payroll system.
    2. Change the date format in the integration from "dd.MM.YYYY" to "dd.MM.yyyy".
    3. Test the integration by running it manually and reviewing the output file.
    4. Confirm that the correct birthdate format is delivered to the payroll system.

    See Also

      Refer to: KBA 2580564 - How to download payload/dump files for debugging - Integration Center

      Keywords

      birthdate, integration center, 31.12., year increment, incorrect date, payroll system, SFTP, merging fields, date format, dd.MM.YYYY, dd.MM.yyyy , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , Problem

      Product

      SAP SuccessFactors Platform all versions