Item Interface Failed To Load Entire Batch Of Items When One Item Fails With A Valid Error (Doc ID 1608761.1)

Last updated on APRIL 03, 2025

Applies to:

Symptoms

When attempting to import multiple items if one of the item is failing with Invalid UOM then all other items in that batch also fails. They does not get imported.

-- Error
TRANSACTION ID : 634551789
ORGANIZATION ID : 91
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME : PRIMARY_UNIT_OF_MEASURE
MESSAGE NAME : INV_IOI_PRIMARY_UOM
ERROR MESSAGE : The PRIMARY_UNIT_OF_MEASURE or PRIMARY_UOM_CODE is not a valid Unit of Measure in MTL_UNITS_OF_MEASURE or the two values are not in agreement.


-- What is working
When there is no UOM error for one record then all records get imported with out any issue.

-- Expected Result

System should import all the good items and should not import the bad item.

 -- Steps
The issue can be reproduced at will with the following steps.
1) Insert into MTL_SYSTEM_ITEMS_INTERFACE with 10 records.
2) For one of these records populate Wrong UOM.
3) Now run Item Open Interface program
4) System fails all the records.

Changes

Cause

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