CROSS_REFERENCE Is Limited To 25 Characters In MTL_CROSS_REFERENCES_INTERFACE
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.
On : 12.2.5 INV RUP 5, invintf.odf: 120.21.12020000.3
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."
Expect MTL_CROSS_REFERENCES_INTERFACE.CROSS_REFERENCE to be 255 because final table supports that size.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms