My Oracle Support Banner

The Definition The Concatenated Columns In View MTL_SYSTEM_ITEMS_KFV Changed After Patching Which Is Causing ORA-06502 Errors (Doc ID 2874783.1)

Last updated on JUNE 03, 2022

Applies to:

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

Symptoms

After patching, the definition of the two CONCATENATED Key Flexfield (KFF) columns
(CONCATENATED_SEGMENTS and PADDED_CONCATENATED_SEGMENTS)  have changed
in view MTL_SYSTEM_ITEMS_KFV.
 
This has caused errors in a custom PL/SQL program that uses the following type declaration:

 

Changes

Applied patches:
• 13728376
• 8728439
• 9908378
• 23630783
• 24818964
• 21198991
• 33154541
• 33389630
• 33192628
• 33128590

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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