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, 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

Environment

SAP SuccessFactors Learning

Cause

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

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]

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

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

Keywords

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

Product

SAP SuccessFactors Learning all versions