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 126.96.36.199.0 and later
Oracle Supply Planning Cloud Service - Version 11.13.17.05.0 and later
Oracle Demand Management Cloud Service - Version 11.13.17.05.0 and later
Oracle Sales and Operations Planning Cloud Service - Version 11.13.17.05.0 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.|
|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|