My Oracle Support Banner

Demand Plan Completes with Error Query validation failed: Global Causal data query does not retrieve expected number of rows (Doc ID 2379755.1)

Last updated on APRIL 28, 2018

Applies to:

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

Symptoms

Demand Plan completes in error if run for shipment history data greater than 700 days . Customer imported shipment history for little over 2 years and when they define plan and run plan for horizon greater than 700 days , plan completes in error. Same plan completes normal for duration of 500 days or less.

Error: Query validation failed: Global Causal data query does not retrieve expected number of rows. Expecting: 911, Got: 906


The issue can be reproduced at will with the following steps:
1.Launch Demand plan with shipment history data greater than 700 days

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.