Execute Rolling Profile Erroring Out When Decode Expression Used
(Doc ID 1912781.1)
Last updated on JULY 30, 2014
Applies to:Oracle Demantra Demand Management - Version 126.96.36.199 and later
Information in this document applies to any platform.
In Demantra 188.8.131.52, 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;')
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!