My Oracle Support Banner

Simulation Engine Errors (Doc ID 1547556.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 7.3.1 version, Engine

When attempting to run engine on simulation mode
the following error occurs.

ERROR
-----------------------
12:32:48:283 12:32:48:283 ERROR SELECT /*+ parallel(s, 6) parallel(m, 2)*/ s.ITEM_ID, s.LOCATION_ID, s.sales_date, (CASE WHEN s.sales_date > ? THEN NVL(FORE_34, 0) ELSE nvl(actual_quantity ,0) + nvl(dc_dm_temp_hist_adj,0)/dc_cd_mult_sd + nvl(dc_dm_perma_hist_adj,0 )/dc_cd_mult_sd END) FROM SDE_1_2798_935 s ,MDP_2798_935_small m Where s.ITEM_ID = m.item_id AND s.LOCATION_ID = m.location_id AND m.do_fore = 1 AND (m.prediction_status = '1') AND s.sales_date > ? ORDER BY s.ITEM_ID, s.LOCATION_ID, s.sales_date
12:32:48:393 12:32:48:393 ERROR - ErrorDescription: ORA-00904: "FORE_34": invalid identifier

 

FORE_34 field does not exist in sales_data table.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. recent clone in the database.
2. run the simulation engine

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run simulations

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
Cause
Solution


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.