SAP Knowledge Base Article - Public

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

Symptom

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

Environment

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(T4CTTIoer.java:445)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

 

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
	at com.plateausystems.elms.framework.financial.impl.MasterInventoryServiceImpl.getMasterInventoryScheduleVO(MasterInventoryServiceImpl.java:447)
	... 185 more

 

Cause

Defect raised and confirmed in LRN-11136

Resolution

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

http://jira.successfactors.com/browse/LRN-11136

Keywords

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

Product

SAP SuccessFactors HCM Core 1511