Item Load 'IN_ITMLOAD' Error 'Record Already Exists: Add Not Allowed' when Adding Location or UOM (Doc ID 2306078.1)

Last updated on AUGUST 27, 2023

Applies to:

Symptoms

Error 'Record Already Exists: Add not Allowed' is returned by the IN_ITMLOAD process when attempting add a new vendor location for an existing item vendor, or when you try adding a new UOM to an existing Location.

The issue can be reproduced at will with the following steps:

1. Create a new item 10000X from 10000 without any Item-Supplier relation
Navigation Items > Define Items and Attributes > Define Item  
2. Load data with Excel to CI (Document 641274.1)
Action = CREATE
CI name = IN_VND_ITM_XLS
3.Run item load (IN_ITMLOAD) process: 1 transactions selected for processing; 0 transactions were rejected due to validation errors.
Navigation Items > Define Items and Attributes > Define Item
4.Item - Supplier was created
5.Add a new location SALES to the same item - supplier 10000X / SCM0000001
Navigation Items > Define Items and Attributes > Define Item  - Purchase Items Attributes link > Supplier Relationship tab
Notice the error: 1 transactions were rejected due to validation errors.
6.Check error
Navigation SCM Integration > Transaction Error Handling > Approve Item Exceptions

If try with Action  = UPDATE the system returns again erros in the Item Loader application engine message log:

In Transaction Error Handling appears error:

Changes

Not applicable. 

Cause

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