MTL_CROSS_REFERENCES_PUB FAILS WITH: The UOM Code <UOM> already exists for <GTIN> (Doc ID 2044397.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Item Master - Version 12.1.3 and later
Information in this document applies to any platform.
MTL_CROSS_REFERENCES_PUB
INVIDXRT.fmb
GTIN
EGO: Enable GTIN Validation = No

Symptoms

On : 12.1.3 version, Change Management

Cross References API (MTL_CROSS_REFERENCES_PUB) fails to create multiple GTIN cross references for same Item/Organization/UOM combination, when EGO: Enable GTIN Validation  = No.


This same functionality is allowed in the form Assign Cross References Form (INVIDXRT.fmb)



ERROR
Error in create_gtin_reference for UPC - The UOM Code <UOM> already exists for <GTIN>.

STEPS
The issue can be reproduced at will with the following steps:
1.Set profile options: INV: GTIN Cross Reference Type  = GTIN  and  EGO: Enable GTIN Validation  = No

2. Using MTL_CROSS_REFERENCES_PUB try to create multiple GTIN cross references for same Item/Organization/UOM combination.



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