SAP Knowledge Base Article - Public

2289627 - LMS Defect:LRN-11136 Exception errors when SKU is removed from item


An exception error appears when admin attempting to add catalog to item or scheduled offering.


SAP SuccessFactors Learning Management - LMS release b1511

Reproducing the Issue

Scenario 1:

1) Create an ITEM1 and remove SKU ID from summary tab
2) Go to Item > Catalog tab and try adding an CAT1 catalog to item


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

	at oracle.jdbc.driver.T4CTTIoer.processError(
	at oracle.jdbc.driver.T4CTTIoer.processError(
	at oracle.jdbc.driver.T4C8Oall.processError(
	at oracle.jdbc.driver.T4CTTIfun.receive(
	at oracle.jdbc.driver.T4CTTIfun.doRPC(
	at oracle.jdbc.driver.T4C8Oall.doOALL(


Scenario 2:

1) After Scenario 1, create a scheduled offering ID: SO1 (Segment date should be in the past)
2) Add back SKU ID in the item summary tab
3) Add catalog CAT1 item > Catalog tab [Catalog is added successfully]
4) Go to Scheduled offering and try to add CAT1 throws following exception error message.


Caused by: com.plateausystems.elms.util.helper.ElmsNoRecordFoundException: Record Not Found
	... 185 more



Defect raised and confirmed in LRN-11136


This issue has been resolved now when editing the SKU for the item that is in the users catalog proper validation message is displayed.

No exception is displayed when editing the SKU for the item that is not in the users catalog.

See Also


SKU, Exception, Error, Item, Catalog, Scheduled Offering , KBA , LOD-SF-LMS , Learning Management System , Problem


SAP SuccessFactors HCM Core 1511