My Oracle Support Banner

Troubleshooting Issues with Data Collections for Items and Catalogs (Doc ID 2238897.1)

Last updated on JUNE 24, 2023

Applies to:

Oracle Fusion Planning Central Cloud Service - Version and later
Oracle Supply Planning Cloud Service - Version and later
Oracle Demand Management Cloud Service - Version and later
Oracle Sales and Operations Planning Cloud Service - Version and later
Information in this document applies to any platform.


 This document walks through the steps on how to Setup an Item and Catalog and troubleshoot Data Collection issues with respect to these entities.




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
 Introduction to Items and Catalogs
 Creating a Catalog, Item and Collecting them into Planning.
Fusion Source
 External Source
 Collections sequence for Item Data
 Review Collected Data.
 Frequently Asked Questions
 Is Item Revision used in Fusion Planning?
 Is it possible to load Item-Organization Level Attributes in Planning?
 Is Product Family supported in Fusion Supply Chain Planning?
 Is multi-level categories supported in Planning?
 Troubleshooting Issues with Items and Catalogs
 ORA-00001: unique constraint (FUSION.MSC_LEVEL_MEMBERS_U1) violated
 WARNING: There is no default catalog available. Therefore, there will not be a Default Product Hierarchy.
 In a given Catalog, only partial categories are collected. Some of Categories are missing.
 After Item Collections, in Plan Inputs, the collected items are not associated with the right Organizations.
 Items Collected into Planning are not visible. Items are available in MSC_SYSTEM_ITEMS.
 The trees <Catalog Name> have certain categories which do not have an item-category relationship. Therefore they were skipped while processing.
 Items are not collected into Planning.
 ORA-00001: unique constraint (FUSION.MSC_CATALOG_CATEGORIES_U2) violated

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