Engine Fails on Price Causal Factor After Upgrade to 7.3.1.4

(Doc ID 1632470.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Predictive Trade Planning - Version 7.3.1.4 and later
Information in this document applies to any platform.

Goal

Customer has upgraded from 7301 to 7314.
Their price1 causal factor has the Local function as:

nvl(sum(#quantity# * item_price), sum(nvl(#FORE@0#,1) * item_price))

After the upgrade the engine fails on this causal factor with the error

14:47:42:871 Calculated last forecast date: 2015-08-03 (42219)
14:47:42:887 ERROR
14:47:42:996 ERROR DB_Command::Execute threw an exception:
14:47:43:106 ERROR SELECT round((CASE WHEN sales_date 14:47:43:215 ERROR - ErrorDescription: ORA-00911: invalid character

14:47:43:324 ERROR - ErrorNumber: 0x80040e14 - Undefined Error.
14:47:43:434 ERROR - NativeErrorNumber: 911
14:47:43:543 ERROR - ErrorDescription: One or more errors occurred during processing of command.
14:47:43:653 ERROR - ErrorNumber: 0x80040e14 - Undefined Error.
14:47:43:762 ERROR - NativeErrorNumber: 0
14:47:43:871 ERROR Local Function defined for causal factor price1 of type price is invalid
14:47:43:981 ERROR HINT: the default local function expression must look like (nvl(,))
14:47:44:090 ERROR for example : sum(nvl(item_price,0))
14:47:44:199 ERROR Engine table validation failed!!!
14:47:44:309 Total Engine Time 0 Hours, 0 Minutes, 2 Seconds


However the same Local function works fine for price1 in their pre upgraded instance

In the upgraded instance, if they change the Local function for price1

From:

nvl(sum(#quantity# * item_price), sum(nvl(#FORE@0#,1) * item_price))

TO:AVG(NVL(item_price,0))

The engine works fine

But the customer needs to use their original local function
 

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