Behaviour When Running Forecasting and Simulation with Decomposition
(Doc ID 2577438.1)
Last updated on NOVEMBER 05, 2020
Applies to:Oracle Demand Management Cloud Service - Version 11.13.19.04.0 and later
Information in this document applies to any platform.
On : 11.13.19.04.0 version, Demand Plan
When attempting to run the demand plan, it fails with below mentioned error. some times plan completetes sucessfully but no decomposition methods details are seen after the plan run
07/29/2019 5:52:42.989 - Run plan returned:: #Version=4.3#Status=ERROR#Branches=-1#Code=402#SetID=0#Tables=MSC_DATA_5003_DYD,MSC_DATA_5004_DYD#Message=Running in Net change mode on All population - - - Query validation failed for: QueryArrayUpdateDataDetail,
) - Query validations have failed! Failed queries: QueryArrayUpdateDataDetail failed: ORA-00904: "MSC_MATRIX_5003_DYD"."CUS_10016_ID": invalid identifier
The issue can be reproduced at will with the following steps:
1. Create Demand Plan
2. Select decomposition methods
3. Run the plan
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