Calendar Week Starts Thursday, MSD_DP_SCN_ENTRIES_DENORM.START_TIME Is Friday and not Thursday
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.
STEPS TO REPRODUCE
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