"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="")
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