SAP Knowledge Base Article - Public

3384141 - MDF - Error: Business key values already exist for another child in the history

Symptom

  • Error when adding Data/record in a custom portlet
  • Receiving following error message: "Business key values already exist for another child in the history ...."

Environment

SAP SuccessFactors HXM Suite

Reproducing the Issue

Data Set up: 

Parent - Object 1

Child  - Object 2 (Country field set as business key)

Both parent and child objects are effective dated objects and there is 1 to many associations between object 1 and object 2.

Steps to reproduce:

  1. Create an object effective from May 1st 2023.
    • Parent object can have any data
    • Child object 1 (External code - "1" and country as USA)
    • Child object 2 (External code - "2" and country as IND)
  2. Create another time slice of same object effective May 2nd 2023
    • Delete this object - Child object 2 (External code - "2" and country as IND)
  3. Create another time slice of same object effective May 3rd 2023
    • Add new child object  - Child object 3 (External code - "3" and country as IND)

Below error message is displayed, on save of MDF object in step 3. 

"Business key values already exist for another child in the history! Object type: cust_child_test, externalCode 3"

Cause

This behavior is expected with current design as this scenario is not supported.

Resolution

Our Engineering team are working to enhance this as part of the 2H 2023 release (For the product release dates see Product Release and Road Map Information | SAP SuccessFactors | SAP Community )

Keywords

MDF-84119, INC5979151 , KBA , LOD-SF-MDF-MGD , Manage Data - Create, Update & Delete , LOD-SF-MDF-OBJ , Object Definition & Field Related Issues , Problem

Product

SAP SuccessFactors HXM Suite all versions