My Oracle Support Banner

DM:Troubleshooting Issues To Forecast Accuracy (MAPE, MAD, BIAS, Archiving, Waterfall Analysis, Trend analysis) (Doc ID 2661777.1)

Last updated on AUGUST 28, 2023

Applies to:

Oracle Demand Management Cloud Service - Version and later
Information in this document applies to any platform.


 This document provides information about Troubleshooting Issues related to Forecast Accuracy (MAPE, MAD, BIAS, Archiving, Waterfall Analysis, Trend analysis)


 The functionality described in 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
 Common Errors
 Following Level does not share  Dimension and Hierarchy of Granularities:Level: Week, Level Type: Worksheet Levels, Granularity Ids [30000000yyyyyyy]
 Error: The Archive Plan Data process is failing with a warning. Measure id: 1234 has expression referencing non-existing measures: <<Measure_code>>
 Biz Error Message: ORA-01476: divisor is equal to zero
 Common Issues
 Issue:  Unable to view the Archive data for last one week, two week etc in either waterfall analysis or trend analysis.
 Issue:  Archival Measure values are not populated in the Table
 Q: How to View Forecast Fit Data?
 Q: How the analytical engine is calculating MAD/MAPE/BIAS?
White Papers

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