SAP Knowledge Base Article - Public

2964989 - Unable to import multiple records with the same data and different effective dates on a custom portlet

Symptom

  • Not able to import multiple entries on custom portlet.
  • An import with same data and different effective date shows successful in Monitor Jobs but is not imported on the Portlet through incremental mode.

Environment

  • SAP SuccessFactors HXM Suite
  • Metadata framework (MDF)

Reproducing the Issue

  1. Navigate to Import and Export Data.
  2. Select the custom MDF object in the Generic Object field.
  3. Select External Code as Key Preference
  4. Select Purge Type as Incremental. 
  5. Import the file for external code and navigate to Monitor Jobs. Status will show as successful.
  6. Navigate to Employee Profile of the user and see that the effective date record imported did not get imported.

Cause

For MDF imports, to avoid accumulation of redundant data by duplicate inserts and unchanged updates, by default the Suppress Redundant Date-Effective Records option is enabled. This eliminates redundant date-effective records and improves performance. You have the option to opt-out of Suppress Redundant Date-Effective Records by selecting No in the Import and Export Data page, if that is decided for the concerned customer or instance.

Resolution

Set Suppress Redundant Date-Effective Records to No so that duplicate entries for different effective dates will be imported in Import and Export Data Page upon import. 

To perform this, please navigate to:

  1. Select Import and Export Data in Admin Center Tools.
  2. Select No for the Suppress Redundant Date-Effective Records field.
  3. Perform the Import once again and select other import fields depending on your requirement. 

See Also

Please also see MDF Help Guide for more information on this. 

Keywords

unable to import multiple records with different effective date but same data, Suppress Redundant Date-Effective Records, custom MDF import different effective date , KBA , LOD-SF-MDF-IMP , Import and Export Issues , Problem

Product

SAP SuccessFactors HXM Core 2005