SAP Knowledge Base Article - Public

3053376 - Additional/Duplicated Competency Libraries and Categories under Manage Center of Capabilities

Symptom

After Competency Libraries were migrated to Center of Capabilities, there are more Libraries and Categories being displayed than what displayed under Manage Job Profile Content before the migration.

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 Center of Capabilities

Reproducing the Issue

  1. Go to 'Manage Center of Capabilities'
  2. See that there are additional Libraries and Categories that were not present pre migration:


Cause

In JPB, it was possible to use the same Library name in different locales, but with the migration to Center of Capabilities, system recognized those as different Libraries altogether.

So, with the migration, system created unique Libraries and Categories for each locale, generating the duplicates with "_*number*" at the end, to differentiate each of them (since they had the same name).

Having competencies in the same library or category with missing or different translation for any specific locales causes this issue in the migration. This can be fixed by making sure all competencies in a specific library and category have all of the same locale filled in. This is explained in further detail in the resolution section.

Resolution

In order to fix this, there are basically three steps to be followed:

  1. Export all Competecies from the affected Libraries and Categories;
  2. Create new Competency Libraries and Categories with the correct names;
  3. Re-import all the Competencies to the new corrected Libraries/Categories.


For that, please follow:


  1. How to create a new Competency Library:
    • Go to "Import and Export Data";
    • On "
    • On "
    • Hit the "Export" button;



    • Go to "Monitor Job" and download the extracted file;
    • On the extracted .zip, open the "CapabilityLibraryStructure.csv" file;



    • Select the Library you would like to "recreate";



    • Rename its "External Code" value with the correct name (without the "_*number*" at the end) - you can do that for all Libraries at once or keep only one record in the file and delete the others;



    • Save the updated file;
    • Go back to "Import and Export Data";
    • On "
    • On "
    • Choose the updated file and hit the "Import" button;



    • Go to "Monitor Job" and confirm that the import was successful;
    • Once you do that, go to "Manage Center of Capabilities" and confirm that the new Library has been properly created.




  2. How to create a new Category:
    • Open the .zip file you have previously exported;
    • Select "CapabilityCategory.csv";



    • Select the Category you would like to "recreate";



    • Rename its "External Code" value with the correct name (without the "_*number*" at the end) - you can do that for all Categories at once or keep only one record in the file and delete the others;



    • Scroll all the way to the right, and on "CapabilityLibraryStructure.External Code", set the new Library name (without the "_*number*" at the end);





    • Save the updated file;
    • Go back to "Import and Export Data";
    • On "
    • On "
    • Choose the updated file and hit the "Import" button;



    • Go to "Monitor Job" and confirm that the import was successful;
    • Once you do that, go to "Manage Center of Capabilities" and confirm that the new Category has been properly created inside the Library you created on step 1.




  3. How to mport all Competencies that have been associated to the different Libraries and Categories to the new ones:
    • Open the .zip file you have previously exported;
    • Select "Competency.csv";



    • Scroll to the "CapabilityLibraryStructure.External Code" and "CapabilityCategory.External Code" columns;
    • Set the new Library and Category names (without the "_*number*" at the end);



    • Save the updated file;
    • Go back to "Import and Export Data";
    • On "
    • On "
    • Choose the updated file and hit the "Import" button;



    • Go to "Monitor Job" and confirm that the import was successful;
    • Once you do that, go to "Manage Center of Capabilities" and confirm that all Competencies are being displayed under the new Library and Category you created on steps 1 and 2. Also confirm that they have been removed from the old Libraries and Categories by opening them and seeing that they are now empty.



  4. How to avoid this issue:
    1. For Production instances, the center of capabilities is not yet live, so to avoid this issue, first, export all competencies using "MDF import/Export", it will fetch library and category of competency in all locale
    2. For given library, keep the locale values consistent in all competency records. So, at the end the same library should have same locale values in all competencies. 
    3. Repeat this step for Categories
    4. Import competencies using "MDF import/export"

Keywords

Center of Capabilities, CofC, Competency, Migration, Extra, Libraries, Competency Library, Category, Duplicated, Names. , KBA , LOD-SF-EP-JPB , Job Profile Builder , Known Error

Product

SAP SuccessFactors HXM Suite 2105

Attachments

Pasted image.png