MTL_CROSS_REFERENCES_PUB FAILS WITH: The UOM Code <UOM> already exists for <GTIN>
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.
EGO: Enable GTIN Validation = No
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 in create_gtin_reference for UPC - The UOM Code <UOM> already exists for <GTIN>.
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.
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