SAP Knowledge Base Article - Public

2253851 - Unable to delete primary records in SAP SuccessFactors Learning

Symptom

  • Is it possible to delete primary records (ex.: Items, classes, content objects/packages, learners/users, domains, categories, curricula, locales, organizations, regions, programs, library, references, etc.) through the front end of SAP SuccessFactors Learning?
  • Domain table dependency locale Key cannot be removed because it is in use
  • How to mass delete incorrect data

Environment

SAP SuccessFactors Learning

Cause

  • The deletion of primary records (ex.: Items, classes, content objects/packages, learners/user, domains, categories, curricula, locales, etc.) from Learning is discouraged and in many cases not possible through the front end of the application.
  • In most cases, the records cannot be deleted due to referential integrity constraints that have been built into the application: the primary records have interacted with other records in the database which has built a chain of relationships in the database structure.
  • Deleting records that are bound to referential integrity constraints, without addressing the appropriate trail of integrity constraints (which can be numerous), can have broad reaching negative impact on the application.
  • For these reasons we recommend inactivating primary records in cases where they cannot be deleted.

Resolution

  • Records can be deleted immediately after creation and before any association with other entities is made.
  • After the record has been associated with other entities, the resolution is to:
  1. "INACTIVATE" the record as in most cases deletion of primary records is not supported in the system >
  2. When this option is unavailable, you may add 'Do Not Use' or a similar message of your choice to the record description and remove from catalog/library access >
  3. Contact our Professional Services team to have a script built to delete the entities.

See Also

2149831 - SAP Professional Services / SAP Certified Partner / SAP Account Management Team [SuccessFactors Cloud] - SAP for Me

2421659 - Steps to be taken before any mass update in LMS instances - SAP for Me

2390982 - Learning admin unable to delete domain restrictions due to validation error - SAP for Me

Keywords

successfactors, lms, deletion, removal, item, user, class, domain, validation, error, curricula, curriculum, program, categories, category, mass, delete, reference, delete, referential integrity constraints, inactivating primary records , KBA , LOD-SF-LMS-ITE , Items , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS-PRO , Programs , LOD-SF-LMS-CUR , Curricula , Problem

Product

SAP SuccessFactors Learning all versions