DM:Troubleshooting Issues Related To Planning Measures
(Doc ID 2667050.1)
Last updated on DECEMBER 15, 2022
Applies to:Oracle Demand Management Cloud Service - Version 11.13.17.05.0 and later
Information in this document applies to any platform.
This document provides information about Working with Measures, Common Errors, FAQ, Enhancements, White Papers and Troubleshooting tips.
The functionality described on this document is applicable to Fusion Demand Management Application
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
|General Information and Setup|
|Issue: Item Global Attributes exist in the msc_dimension_prd_dyd table but are not visible in Demand Plan tables. For example, Item <Item Name>, which has attribute loaded in msc_dimension_prd_dyd table but not shown in plan.|
|Issue: The user has created a user-defined measure MeasureA with expression measureB + measureC where the calculation is not working as expected.|
|Issue: User-defined measure is not calculated in the table after the plan run.|
|Issue: The user successfully loaded measure at an aggregate level, bug after the demand plan run the data is not shown in the table.|
|Error: The current selection does not contain any editable measures.|
|Issue: Unable to use a measure based on Item Attribute: ITEM_COST_OVERRIDE with error: “An error occurred. Your help desk was notified.”|
|Frequently Asked Questions|
|Q: Should users edit seeded measures or duplicate them? What is the best practice?|
|Q: How to define not editable measure in the past but editable in the future?|
|Q: Seeded measure doesn’t include decimals in the value. How can to change this?|
|Q: How to update editable measures other than in the user-interface?|
|Frequently Used SQL|
|Known Measure Related Ideas/Enhancements|