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

Applies to:

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

Symptoms

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

[error creating oracle.retail.stores.commerceservices.item.item.importdata.dto.StockItemDTO@a56e70[changeTypeAttribute=UPS,iDAttribute=0056938,uOMAttribute=,colorAttribute=, sizeAttribute=,styleAttribute=,supplierIDAttribute=100798,packItemW...][Update: oracle.retail.stores.commerceservices.item.item.importdata.dto.StockItemDTO@a56e70[changeTypeAttribute=UPS,iDAttribute=0056938,uOMAttribute=,colorAttribute=, sizeAttribute=,styleAttribute=,supplierIDAttribute=100798,packItemWeightCo...][ORA-01400: cannot insert NULL into ("ORBO_OWNER"."AS_ITM_STK"."LU_UOM_SLS")...]



Steps to Reproduce:

1. Create a non-sellable item in Retail Merchandising System (RMS).
2. Import the item into Back Office; sample Item import is given below and note that UOMCode is null (UOMCode="").

<?xml version="1.0" encoding="UTF-8"?>
<ItemImport
   Priority="0"    FillType="DeltaIncremental"    Version="1.0"    Batch="1"
   CreationDate="2014-08-12T20:48:28.0Z">
   <Item
      ChangeType="ADD"
      ID="100054575"
      Type="Stock"
      ItemCost="276.45"
      Taxable="false"
      POSDepartmentID="29"
      Size=""
      Color=""
      RegistryEligible="true"
      SizeRequired="false"
      AuthorizedForSale="true"
      SerializedItem="false"
      Discountable="true"
      DamageDiscountable="true"
      UOMCode="">
      <ShortName>Mora Gold blanket double</ShortName>
      <LongDescription>Mora Gold blanket double</LongDescription>
      <MerchandiseHierarchy>5:002901420456</MerchandiseHierarchy>
      <RetailStoreItem
         VatCode=""
         ChangeType="ADD"
         AgeRestrictionId="0">
         <RetailStoreID>04241</RetailStoreID>
         <RegularPrice
          CurrencyCode="USD"
          IncludesTax="false">670</RegularPrice>
         <POSIdentity
            ChangeType="ADD"
            POSItemID="1234560016044"
            SupplierID="296"
            MinimumSaleUnitCount="1"
            QuantityModifiable="Optional"
            PriceEntryRequired="false"
            PriceModifiable="true"
            SpecialOrderEligible="false"
            Returnable="true"
            EmployeeDiscountAllowed="true"/>
      </RetailStoreItem>
   </Item>
 </ItemImport> 

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.

Changes

 

Cause

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

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


In this Document
Symptoms
Changes
Cause
Solution
References


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