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:
- "INACTIVATE" the record as in most cases deletion of primary records is not supported in the system >
- 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 >
- Contact our Professional Services team to have a script built to delete the entities.
See Also
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 , Learning Management System , LOD-SF-LMS-ADM , System Admin, Global Variables, References , Problem
Product
SAP SuccessFactors Learning all versions