SAP Knowledge Base Article - Public

3725833 - Error when adding business key for MDF object

Symptom

  • An error occurs when attempting to add a business key for an MDF object
  • Error message: "There are existing records that have duplicate business key values but different external codes. Please correct them."
  • The MDF object might no longer contains data, but the operation to maintain the business key still fails.

Environment

SAP SuccessFactors HCM Suite

Reproducing the Issue

  1. Attempt to add a business key for the MDF object 
  2. Receiving the error message "There are existing records that have duplicate business key values but different external codes. Please correct them."

Cause

The issue is caused by records created with workflows that were later rejected, resulting in duplicate business key values with different external codes.

Resolution

  1. Set up a DRTM Workflows Purge to clear completed workflows as per the KBA 2628645 - How To Set Up Workflow Purge via Schedule job for DRTM Workflows - SAP for Me.
  2. Use the DRTM_COMPLETED_WORKFLOWS option to clear the affected data without impacting other workflows.
  3. Refer to Data Included in the DRTM Workflows Purge | SAP Help Portal for additional details on the purge process.

Keywords

mdf object, business key error, duplicate values, external codes, workflow rejection, successfactors onboarding, cust_employeeID, mdf object error, workflow purge, drtm_completed_workflows, data purge, error message , KBA , LOD-SF-MDF-OBJ , Object Definition & Field Related Issues , Problem

Product

SAP SuccessFactors HCM Suite all versions