System.Exception: DI:1470000365 - UoM specified is not assigned to item in row

System.Exception: DI:1470000365 - UoM specified is not assigned to item in row

Problem

You might face an issue with the integration record failed with the below error: -
System.Exception: DI:1470000365 - UoM specified is not assigned to item in row 1

Cause

 This error occurs when the UoM specified is not assigned as the  Sale UOM for the concerned item.

Steps for Resolution

Pick the source key from the integration monitor and check the Uom Key from Integration_Transaction procedure.
             exec Integration_Transaction 'Source Key'
 
Get the Uom entry from CXSINTEGRATION database by the help of the query
             select SBOID from IntegrationMApping WHERE DBNAME = 'SAPDBNAME' and ObjectID = 265 and IVENDID = {iVendUomKey}
 
Get the UOM code from the SAP database by the help of the query:
              Select UomCode FROM OUOM WHERE UomEntry = {SBOID from the above query}
 
Open SAP and goto Main Menu >> Inventory >> Item Master Data
Open the problematic Item Master Data (One can get the item code from Integration_Transaction procedure).
Click on the Sale Data tab, then expand the sale UOM list.



       
  • The  UOM code from the above query should be available under the Sales Uom list of the Item in SAP
    .
           

 
​In case the UOM is not available in the list, then scroll down the list and click on the Add rows and add the Missing UOM code.