Error When Creating New Series With FORE Function (Doc ID 2062748.1)

Last updated on JUNE 23, 2017

Applies to:

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

Goal

We are facing an issue in the Demantra business modeler when creating (or saving existing) server expressions that use the FORE function.

If we try to save an expression that references a 3-digit engine profile ID we get the "Invalid Expression" error and cannot save the series.
However, if we use a 1 or 2-digit engine profile ID it works.

We have confirmed in the engine_profiles table that they are both valid engine profile IDs.

Expression is invalid: SUM(( nvl((#FORE@0@241#),0) )*#UNIT#)
Expression is valid: SUM(( nvl((#FORE@0@1#),0) )*#UNIT#)
 

Solution

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