Warning in running replenishment plan (including forecast) — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Warning in running replenishment plan (including forecast)

Summary:

Warning for demand start demand planning manager. Plan keeps erroring out after I set calendar to week. The calendar is in dimension catalog and is collected.

Content (please ensure you mask any confidential information):

Query for engine dates retrieves nothing. Engine can not proceed. Verify that planning time level exists in time dimension table: select count(*) from MSC_DIMENSION_TIM_DYD where AGGR_TIM_LEVEL_ID = 10002 If it retrieves positive number check out original SQL with following bind variables: 104,1,0,0,0,1,1,0,10002 SQL : SELECT * FROM (SELECT rownumber,sdate,udate,lag(sdate,?) over (order by sdate) as startDate,lag(sdate,?) over (order by sdate) as lastDate,lag(TIM_10002_ID,?) over (order by sdate) as julianFirstForeDate,lag(sdate,?) over (order by sdate) as firstForeDate,lag(udate,?) over (order by sdate) as foreUntilDate,lag(sdate,?) over (order by sdate) as lastCompleteForeDate,lag(udate,?) over (order by sdate) as lastCompleteForeUntilDate,lead(sdate,?) over (order by sdate) as foreLockedDate from

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!