My Oracle Support Banner

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

Last updated on FEBRUARY 28, 2019

Applies to:

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


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#)


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.