Symptom
- Is it possible to delete primary records (ex.: Items, classes, content objects, 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, content objects, 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
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
SAP Knowledge Base Article - Public