SAP Knowledge Base Article - Public

2253851 - Unable to delete Primary Records in LMS

Symptom

Is it possibe to delete primary records from LMS?

Environment

SuccessFactors Learning Management System (LMS) - All Supported Versions

Cause

The deletion of primary records (items, scheduled offerings, learners, domains, subject areas, curricula, locales, etc.) from the Successfactors LMS 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.
  3. contact our Professional Services team to have a script built to delete the entities

See Also

2149831 - How and When to reach out - Professional Services Consultant, Partner and Account/Finance Team

Keywords

deletion of primary record; delete item; delete user; delete scheduled offerings; delete curricula; delete programs; delete subject area; delete domain; table dependency; locale; Primary; Key; Primary Key , KBA , LOD-SF-LMS-DB , DB Data & Services , Problem

Product

SAP SuccessFactors Learning all versions