Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

When running Demand Plan Start Demand Planning Engine Manager in going into warning

in Supply Chain Planning and Collaboration 4 comments

Summary: We are seeing the below in the log file of Start Demand Planning Engine Manager Job

- Refresh selected

 - *** Query validation failed: Matrix validation failed. Matrix is empty. Try running with full refresh. Expecting: 1 rows, Got: 0 Bind Variables: [], SQL: select count(*) from ( SELECT * from MSC_MATRIX_63001_DYD where rownum=1 )

 - Query validation failed: Matrix validation failed. Matrix is empty. Try running with full refresh. Expecting: 1 rows, Got: 0 Bind Variables: [], SQL: select count(*) from ( SELECT * from MSC_MATRIX_63001_DYD where rownum=1 ) - 

Content (required): Loaded the Shipments History for the measure - Shipments History: Requested Item by Shipped Date, The default profile option is also set to the required value. We are able to open the plan and view the Items in the Items table. However looks like combinations are not getting created in the matrix table of the plan. Also validated with backend query that shipments history is available and causals are also loaded for the past and future buckets

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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