My Oracle Support Banner

S&OP Plan Errors out for ESS Job - Start Demand Planning Engine Manager (Doc ID 2405428.1)

Last updated on JUNE 21, 2018

Applies to:

Oracle Supply Planning Cloud Service - Version 11.13.17.11.0 and later
Information in this document applies to any platform.

Symptoms

S&OP Plan Errors out for ESS job 'Start Demand Planning Engine Manager'

S&OP planning run fails at Demand Planning step after running Refresh Data. It is failing for job Start Demand Planning Engine Manager

ERROR
-----------------------
Query validation failed: Proport table validation failed. No active combinations
Expecting: 1, Got: 0, SQL: select count(*) from ( select * from MSC_DATA_11002_DYD where ship_forecast_status = 1 and rownum=1 ) Bind Variables: []##Priority=1#0#WDC=0#WDM=0


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Sales and Operations Planning
2. Select Manage Plans and run plan
3. Plan fails


Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.