SAP Knowledge Base Article - Public

2253851 - Unable to delete primary records in SAP SuccessFactors Learning


  • Is it possible to delete primary records (ex.: Items, classes, learners/users, domains, categories, curricula, locales, 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


SAP SuccessFactors Learning


  • The deletion of primary records (ex.: Items, classes, 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.


  • 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]

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

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


successfactors, lms, deletion, removal, item, user, class, domain, validation, error, curricula, curriculum, program, categories, category, mass, delete, reference, delete , KBA , LOD-SF-LMS-DB , DB Data & Services , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS , Learning Management System , Problem


SAP SuccessFactors Learning all versions