Exported MAPE Values in MSD_DP_SCN_ENTRIES_DENORM Table do not Match the MAPE Values in Demantra

(Doc ID 1320213.1)

Last updated on DECEMBER 18, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 and later
Oracle Demand Planning - Version to [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 06-Mar-2013***


On Demantra version 7.3.0 integrated with EBS/VCP version

The MAPE uploaded from Demantra to MSD_DP_SCN_ENTRIES_DENORM table in VCP instance is in decimals (ex 0.1) instead of percentage. This causes huge inventory shortages.

Expect Demantra to upload the value as percentage.

The issue can be reproduced at will with the following steps:
1. Log in to Workflow Manager.
2. Execute the EBS Upload Local Forecast workflow.
3. Review the data in the MSD_DP_SCN_ENTRIES_DENORM table.

The issue has the following business impact:
Causes the safety stock levels calculated during Inventory Optimization plan run to be too low causing a shortage.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms