Error When Creating New Series With FORE Function
Last updated on JUNE 23, 2017
Applies to:Oracle Demantra Demand Management - Version 188.8.131.52 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#)
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