Rolling Profiles Failing In Demantra 7.3.0.2 (Doc ID 1532640.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

 On :  7.3.0.2 version,

When attempting to execute execute_profiles ,
when rolling profiles is run for a profile in which source series has a longer server expression. Following is the error we are getting
'Error description 'Database internal error:ORA-20002: -24344 ORA-24344: success with compilation error Error in PROCEDURE EXECUTE_PROFILES line 1287''


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Go to Business Modeler > Engine Data > Rolling Data
2. Select a profile in the configure sessions window of Rolling Profile which has source series having a long server expression.
3. Run execute_profiles from workflow manager

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