My Oracle Support Banner

"ORA-01400: Cannot Insert NULL into AS_ITM_STK.LU_UOM_SLS" is Thrown When Item Import for a Non-Sellable Item has UOMCode as Null (UOMCode="") (Doc ID 2004522.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Retail Back Office - Version 13.4.1 and later
Information in this document applies to any platform.


When attempting to import a non-sellable item whose UOMCode is null (UOMCode=""), the following error occurs:

3. Check Back Office log and note that 'ORA-01400: cannot insert NULL into ("ORBO_OWNER"."AS_ITM_STK"."LU_UOM_SLS")...]' is reported.

AS_ITM_STK.LU_UOM_SLS should be defaulted to "UN" for "units" if not specified through ItemImport/Item@UOMCode in the item import xml.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.