DM BAL Upgrade From 7.3.12 To 7.3.1.4 fails with Check_Fore_Series_by_Profile issues (Doc ID 1542285.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 7.3.1.4 and later
Information in this document applies to any platform.

Symptoms

On : 7.3.1.4 version, BAL
When attempting to upgrade from 7312 to 7314, the upgrade gets stopped into a BAL issue, - Upgrade Schema Option and Automatic Upgrade with Platform and Application Option.
While Validating the series at "Validating BAL Import" Screen it gave ora-20002 error. Although all the functionality checked are working fine; version_details_history is not updated; only BM appears to have the new version mark.

CHECK_FORE_SERIES_BY_PROFILE -1 ORA-00001: unique constraint (DEMANTRA.FORECAST_HISTORY_PK) violated Error in PROCEDURE line 388
dynamic_ddl( 'INSERT INTO forecast_history ( time_sig , status, engine, engine_profiles_id , init_params_table_name , fore_column_name ) VALUES ('01-21-1901 00:00:00', 2, 0,'106', 'INIT_PARAMS_141' ,'FORE_15')')
GET_EXP_WITH_NO_TOKEN -20005 ORA-20005: ii_profile_id=269 is not valid Error parsing expression sum(#FORE@0@269#*1)

Upgrade stopped

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