My Oracle Support Banner

Troubleshooting Issues with Data Collections for Item Structures and Work Definitions (Doc ID 2698362.1)

Last updated on MAY 27, 2024

Applies to:

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

Purpose

 This Document provides information about troubleshooting Issues with Data Collections for Item Structures and Work Definitions

Scope

 Functionality described on this document is applicable to Oracle Cloud Supply Chain Planning.

Details

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
Purpose
Scope
Details
  
 Frequently Asked Questions
 If a Work Definition exists for an Item then Planning does not appear to consider the item structure. Is this functionality as designed?
 Why does the changes made in the PIM Item Structure not get collected in Planning after running collections?
 Does Supply Planning support component yield greater than 1?
 Common Issues
 Item structures and work definitions are not getting collected even after multiple Collection runs.
 The value provided for the attribute UOM_CODE is invalid.
 The value provided for the attribute DEPARTMENT_CODE is invalid.
 The value provided for the attribute ASSEMBLY_NAME OR ORGANIZATION_CODE OR ALTERNATE_BOM_DESIGNATOR is invalid.
 ORA-00001: unique constraint (FUSION.MSC_ROUTING_OPERATIONS_U2) violated
 Unable to derive Department Id. Unable to derive Resource Id. 
 A record already exists with the same combination of values for the key attributes ASSEMBLY_NAME <name> ORGANIZATION_CODE <org>
  

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