"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!