CROSS_REFERENCE Is Limited To 25 Characters In MTL_CROSS_REFERENCES_INTERFACE (Doc ID 2241297.1)

Last updated on MARCH 07, 2017

Applies to:

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

Symptoms

On : 12.2.5 INV RUP 5, invintf.odf: 120.21.12020000.3

ACTUAL BEHAVIOR
---------------
Cannot import rows into MTL_CROSS_REFERENCES_INTERFACE where CROSS_REFERENCE greater than 25 characters.

MTL_CROSS_REFERENCES_INTERFACE.CROSS_REFERENCE size is 25, although MTL_CROSS_REFERENCES.CROSS_REFERENCE size is 255. Cross Reference names which have more than 25 characters cannot be inserted into the interface table.

MTL_CROSS_REFERENCES_INTERFACE.CROSS_REFERENCE Size Is 25, Although MTL_CROSS_REFERENCES.CROSS_REFERENCE Size Is 255 (Doc ID 2184477.1) mentions that we need to upgrade invintf.odf to a version > 120.16.1210000.8. However, this note applies only to release 12.1.3.

This fix is in the newest version of invintf.odf 120.21.12020000.5; this is delivered in patch 23736595:R12.ITM.D. However, this patch is not released and Development management stated "The patch being developed is an internal only patch. Please log a bug for a patch to be built for the customer."


EXPECTED BEHAVIOR
-----------------------
Expect MTL_CROSS_REFERENCES_INTERFACE.CROSS_REFERENCE to be 255 because final table supports that size.



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