Calendar Week Starts Thursday, MSD_DP_SCN_ENTRIES_DENORM.START_TIME Is Friday and not Thursday

(Doc ID 2127890.1)

Last updated on JUNE 09, 2016

Applies to:

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


Calendar Week Starts Thursday,however MSD_DP_SCN_ENTRIES_DENORM.START_TIME Is Friday

You want their weeks to start on Thursday. In ASCP, you run legacy collections and have loaded a calendar so that the first day of the week is on Thursday. In Demantra, you have entered their forecast with Thursday also being the first day of the week. The problem is that when you collect the forecasts to ASCP (MSD_DP_SCN_ENTRIES_DENORM), the START_TIME column is a Friday. When you look at BIEO_Exp_Cns_Fcst_Org_Week, the start time is still Thursday.


When the Forecast is loaded from Demantra, the expectation is that the START_TIME column should be on a Thursday as well.

1. Create a Demantra forecast.
2. Load it into VCP.


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