CDP Store Sell Through Forecast Batch Engine Failing - ErrorDescription: ORA-00904: "D12": invalid identifier (Doc ID 2024243.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.2.4.1 version, Engine

When attempting to run engine in CDP Store Sell through Bath profile
the following error occurs.

ERROR
-----------------------
09:12:12:132 WARNING Failed to locate any nodes under the TOP level branches: 3, please check configuration (or load data)!
09:12:12:241 1 branches were created.
09:12:12:303 Creating engines...
09:12:12:553 Engine (ID: 0) on machine localhost was successfully created and initialized
09:12:12:553 1 engines were created.
09:12:13:785 Computer localhost speed = 1.39
09:12:14:924 09:12:14:924 WARNING InitParam.RunInsertUnits is incorrectly set to 3 while using a GL profile, forcing value to 0 (No future rows will be inserted).
09:12:15:080 09:12:15:080 ERROR ---------------------------------------------------------------
09:12:15:189 09:12:15:189 ERROR DB_Command::Execute threw an exception:
09:12:15:298 09:12:15:298 ERROR SELECT datet ,CONSTANT,t,d1,d2,d3,d4,d5,d6,d7,d8,d9,d10,d11,d12 FROM INPUTS_DAILY WHERE datet BETWEEN ? AND ? ORDER BY datet
09:12:15:408 09:12:15:408 ERROR - ErrorDescription: ORA-00904: "D12": invalid identifier

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Engine Administrator
2. run engine in CDP Store Sell through Bath profile


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot generate forecast .

Cause

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 hundreds of Community platforms