SAP Knowledge Base Article - Public

2352071 - The HRIS Sync Mapping of a EC Date field to a Custom EP field is the Incorrect Format

Symptom

You have defined an  HRIS Sync Mapping to map an EC Date field to a custom EP field for example:

<hris-mapping>
   <hris-field-ref refid="start-date"/>
   <standard-element-ref refid="custom09"/>
</hris-mapping>

The value is mapping across in the wrong format, for example the value in custom09 is in format "YYYY/MM/DD" and you wish it to be in format "DD/MM/YYYY"

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 Employee Central

Reproducing the Issue

You can define the date format of the field you wish to map in the HRIS Sync Mapping, for example:

<hris-mapping >

   <hris-field-ref refid="seniorityDate" date-format="MM/dd/yyyy"/>
   <standard-element-ref refid="custom13"/>
</hris-mapping>

3bestpng.png

The Date format "DD/MM/YYYY" is not supported.

Cause

The date format is not maintained in the HRIS Sync Mapping.

Resolution

List of supported date formats for hris field: yyyy, MMM-yyyy, MMM, dd/MMM, MM/dd/yyyy

You can only sync an HRIS field of date type to a standard element of string type.

You can use the date-format attribute to define in which formats dates are synchronized . You can only use the following date formats, which are case-sensitive:

  • Year in four digits: yyyy

  • Month and year: MMM-yyyy

  • Month: MMM

  • Day and month: dd/MMM

  • Month, day, and year: MM/dd/yyyy

  • The date-format attribute allows you to sync only parts of the date. This is an example of sync mapping that only syncs the day and month, but not the year for birthday information.

Example from Master data Model

<hris-element-ref refid="personInfo">
      <hris-mapping >
        <hris-field-ref refid="date-of-birth" date-format="dd/MMM"/>
        <standard-element-ref refid="custom01"/>
      </hris-mapping>
    </hris-element-ref>

 

FAQ - Additional Information

Q) Where can I get information on this from the Guide?

A) Guide: Employee Central Master Guide  

    Chapter: Hard-Coded for Syncing

    Chapter: Human Resource Information System (HRIS) Synchronization 

    Chapter: Human Resource Information System (HRIS) synchronization is a one-way sync

See Also

Keywords

HRIS Sync Mapping, Date, Date Format, Date of Birth, Hire date , KBA , LOD-SF-EC-HRS , HRIS Sync , LOD-SF-EC-PER-PRS , Personal Info - Config, Rules, RBP, UI , Problem

Product

SAP SuccessFactors Employee Central all versions