MTL_CATEGORIES_KFV Has NULL Concatenated Segments - Causes Application Failures For ASCP (Doc ID 2485957.1)

Last updated on MARCH 02, 2019

Applies to:

Goal

After compiling the Inventory Item Categories flexfield referenced in Doc ID 2258445.1, still returning rows when running the following:

SELECT COUNT(1)
FROM MTL_CATEGORIES_KFV
WHERE CONCATENATED_SEGMENTS IS NULL;

Changing to a select * gives the following:

CATEGORY_ID   STRUCTURE_ID
-----------          ------------
XXXXX              XXXXX

This causes the failure when running Data Collections for ASCP applications
 

Solution

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