My Oracle Support Banner

DM:Troubleshooting Issues Related To Planning Measures (Doc ID 2667050.1)

Last updated on OCTOBER 12, 2023

Applies to:

Oracle Demand Management Cloud Service - Version 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
 Dimension Parameters
 Disaggregation Parameters
 Measure Expression
 Level Attribute
 Measure Troubleshooting
 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.
 Common Errors
 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
 White Papers
 Known Measure Related Ideas/Enhancements

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