My Oracle Support Banner

Dem "Failed To Retrieve History Information, Check Validity Of Local Causal Expressions" (Doc ID 1998093.1)

Last updated on MARCH 08, 2017

Applies to:

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


On : version, Worksheet

When attempting to run engine,
the following error occurs in engine manager log file


SELECT  sales_date datett, round(sum(greatest(nvl(pseudo_sale,nvl(actual_quantity, src_actual_quantity))*(1 + nvl(demand_fact,0)),0)),6) sales,  round(max(sales_data.causal_tv_flag),6) , sqrt(avg (power (nvl (decode(obs_error_std,0,1,obs_error_std),1),2))), nvl(sum(nvl(UP_TIME,1)),1) FROM SDE_1 s,MDP_1 m WHERE ( (sales_date <=? and sales_date >= ? and  greatest(nvl(pseudo_sale,nvl(actual_quantity, src_actual_quantity))*(1 + nvl(demand_fact,0)),0) is not null ) or sales_date > ? ) and  m.T_EP_ITEM_EP_ID = ?  AND m.T_EP_ORGANIZATION_EP_ID = ? AND s.ITEM_ID = m.item_id AND s.LOCATION_ID = m.location_id  GROUP BY sales_date ORDER BY datett
10:43:15:504 <UKF6-SDEVDEMW02-0> 10:43:15:504 ERROR   - ErrorDescription: ORA-00904: "SALES_DATA"."CAUSAL_TV_FLAG": invalid identifier

The issue can be reproduced at will with the following steps:
1. Created new series called Causal TV Promo Flag (causal_tv_flag).
It is a numeric series with a drop-down list for values .The server expression is max(branch_data.causal_tv_flag).

2. Created a new local causal factor called TVPromo with the  location function = max(sales_data.causal_tv_flag).

3. In the worksheet I assigned the value  in the series Causal TV Promo Flag for several historic rows of the lowest level sku-store combination. I assigned this flag to rows where the sales quantity is higher than usual.

4. After this I assigned the same causal value to future rows . I saved data.

5. Next I run the engine and recieved a error message in engine manager log.

6. I checked the worksheet and I can only see forecast values of 0s for all lowest level combinations (sku-store) but when I look at a higher level such as brand and country I can see a forecast.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.