My Oracle Support Banner

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.

Symptoms

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

ERROR

....

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
....


STEPS
The issue can be reproduced at will with the following steps:
1. Create Demand Plan
2. Select decomposition methods
3. Run the plan

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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.