DM BAL Upgrade From 7.3.12 To 22.214.171.124 fails with Check_Fore_Series_by_Profile issues
Last updated on SEPTEMBER 08, 2016
Applies to:Oracle Demantra Real-Time Sales and Operations Planning - Version 126.96.36.199 and later
Information in this document applies to any platform.
On : 188.8.131.52 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)
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