Item Import: INVPPROC UOM_Process Cursor Causes Unique Constraint on Insert Into Mtl_uom_conversions (Doc ID 2218405.1)

Last updated on JANUARY 03, 2017

Applies to:

Oracle Item Master - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Item Issues

INVPPROC UOM_Process cursor causes error in insert into mtl_uom_conversions

The UOM_Process cursor in the INVPPROC package body causes a ORA-00001 unique constraint error during INCOIN (Item import). This occurs when a single item with item specific UOM conversions is added to more than 1 child orgs in a single INCOIN run.



ERROR
-----------------------
There is a UOM_Process cursor that is inserting multiple rows into the mtl_uom_conversion table and hits a uniqueness constraint after the first record is processed.

TRANSACTION ID : 1
ORGANIZATION ID : XXX
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME : INVENTORY_ITEM_ID
MESSAGE NAME : INV_IOI_ERR
ERROR MESSAGE :
[02-AUG-2016 10:15:20] **> INVPUOPI.mtl_log_interface_err: TRANSACTION ID : 1
[02-AUG-2016 10:15:20] **> INVPUOPI.mtl_log_interface_err: ORGANIZATION ID : XXX
[02-AUG-2016 10:15:20] **> INVPUOPI.mtl_log_interface_err: TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
[02-AUG-2016 10:15:20] **> INVPUOPI.mtl_log_interface_err: COLUMN NAME : INVENTORY_ITEM_ID
[02-AUG-2016 10:15:20] **> INVPUOPI.mtl_log_interface_err: MESSAGE NAME : INV_IOI_ERR
[02-AUG-2016 10:15:20] **> INVPUOPI.mtl_log_interface_err: ERROR MESSAGE :
[02-AUG-2016 10:15:20] **> INVPUOPI.mtl_log_interface_err: msg_name = INV_IOI_ERR


Cause

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