INVICITM Can Not Query Customer Cross Reference Item Receive: A Customer Item Cross Reference Record With the Same Customer Item_id, Master Organization_id, Inventory Item_id, and/or Rank Combination Already Exists. (Doc ID 2443720.1)

Last updated on FEBRUARY 10, 2022

Applies to:

Symptoms

INVICITM Can Not Query Customer Cross Reference Item

Customer cross reference item is not appearing on the form.

However, when trying to add, receive a message 
The information does show at the database level in the MTL_CUSTOMER_ITEM_XREFS_V table.

ERROR
-----------------------
A Customer Item Cross Reference Record With the Same Customer Item_id, Primary Organization_id, Inventory Item_id, and/or Rank Combination Already Exists. 

Cause

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