"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 MARCH 10, 2017

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.




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 hundreds of Community platforms