Symptom
- Duplicate Divisions are showing in Manage Data or Company Structure Overview
- Duplicate Departments are showing in Manage Data or Company Structure Overview
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
- Employee Central – Company Structure Overview
- Employee Central – Manage Data
Reproducing the Issue
In Manage Data:
- Navigate to Manage Data;
- Select Division from the first dropdown box;
- Select the second dropdown box;
- Duplicates appear.
In Company Structure Overview:
- Navigate to Company Structure Overview;
- Select a Company Structure;
- Select ‘Division’ from the dropdown;
- Duplicates appear.
Cause
When fetching the records, the optimized single query approach is being used (which is causing duplicate results).
Resolution
In Manage Data, please create an Object Configuration for the duplicated objects (Division & Department) and set disableOptimizeAutoCompleteQuery to 'Yes'.
This means that there will be two queries (one for count, another for fetching actual distinct records) for autocomplete search instead of optimized single query approach.
Keywords
duplicate, repeat, repeated, manage data, company structure overview, XAF-22053, Object Configeration, Division, Department, CSO , KBA , LOD-SF-EC-CSO , Company Structure Overview , Known Error