Execute Rolling Profile Erroring Out When Decode Expression Used
(Doc ID 1912781.1)
Last updated on FEBRUARY 27, 2019
Applies to:
Oracle Demantra Demand Management - Version 7.3.1.5 and laterInformation in this document applies to any platform.
Symptoms
In Demantra 7.3.1.5, when the decode expression is used in the server expression of a series and if that series is a source in rolling profiles definition, the rolling profile errors out and the error is in the db_exception_log table as shown below:
-6550 ORA-06550: line 1, column 7:
PLS-00905: object ROLLING_UPDATES is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored Error in PROCEDURE line 2952
dynamic_ddl( 'BEGIN ROLLING_UPDATES; END;')
Cause
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
Symptoms |
Cause |
Solution |
References |