ORA-03001 Unimplemented Feature After Upgrade Demantra From 12.2.3 To 12.2.5.1

(Doc ID 2147892.1)

Last updated on JUNE 26, 2017

Applies to:

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

Symptoms

On : 12.2.5.1 version, DM-Gen

Got worksheet error ORA-03001 Unimplemented feature after upgrade Demantra from 12.2.3 to 12.2.5.1

Customer is performing an upgrade from Demantra 12.2.3 to 12.2.5.1. (Upgrade Schema -> Platform Upgrade only). After the upgrade, when they launched Tomcat we got the following error:

ERROR appserver.thread:
java.sql.SQLException: ORA-03001: unimplemented feature

Upon turning on the sql logging they got the last query that comes up before the error comes up. Then ran the query on command lune and got the same error. Found that in the last query, the function Z_FN_get_max_date shows like this:

Z_FN_get_max_date(0)()

Which should be

Z_FN_get_max_date()

And it causes this error.

The DDL for the function z_fn_get_max_date():

create or replace
FUNCTION z_fn_get_max_date
RETURN date
IS
ret_date date;
BEGIN

ret_date := to_date(get_max_date(),'MM-DD-YYYY HH24:MI:SS');

RETURN ret_date;
END;



 

ERROR
-----------------------

ERROR appserver.thread:
java.sql.SQLException: ORA-03001: unimplemented feature



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Upgrade Demantra instance
2. Start the webserver

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use Demantra application

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