Calendar Week Starts Thursday, MSD_DP_SCN_ENTRIES_DENORM.START_TIME Is Friday and not Thursday
(Doc ID 2127890.1)
Last updated on FEBRUARY 03, 2019
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.
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