2165780 - Error ORA-01400 When Adding a Catalog to an Item in SuccessFactors Learning

SAP Knowledge Base Article - Public

2165780 - Error ORA-01400 When Adding a Catalog to an Item in SuccessFactors Learning

Symptom

The following error is seen when adding an Catalog to an Item in LMS

Error
Please report the following error to your system administrator: com.plateausystems.elms.util.helper.ElmsCreateException: SQLException - CatalogServiceImpl.createCatalogItemPrices failed:

Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into (PA_CATALOG_ITEM_PRICE"."SKU")

Environment

SuccessFactors Learning

Reproducing the Issue

  1. In LMS Admin, Go to an item
  2. click on the Catalogs tab
  3. Then click the green plus sign to add a catalog
  4. At this point you may receive a popup with the java stack trace

Cause

This issue may happen if there is no SKU in the master inventory, or if there was one in the past but it had been removed

Resolution

  • The easiest workaround for this issue is to create a copy of the old item
  • It may be a good idea to make the old item a substitute for the new item for any new assignments that might occur
  • Creating a copy of te item should add a new SKU to the master inventory

Keywords

KBA , LOD-SF-LMS , SuccessFactors Learning , Problem

Product

SuccessFactors Learning 1207 ; SuccessFactors Learning 1210 ; SuccessFactors Learning 1302 ; SuccessFactors Learning 1305 ; SuccessFactors Learning 1308 ; SuccessFactors Learning 1311 ; SuccessFactors Learning 1405 ; SuccessFactors Learning 1408