RMS Database 14.0.1 to 14.1 Upgrade Fails With "ORA-00955" Error (Doc ID 2023440.1)

Last updated on APRIL 10, 2017

Applies to:

Oracle Retail Merchandising System - Version 14.1 and later
Information in this document applies to any platform.

Symptoms

Retail Merchandising System (RMS) database schema upgrade from 14.0.1 to 14.1 is failing with the below issue:

1.  Initially installer failed creating an index CHK_FIF_GL_CRS_RF_TRAN_REF_NO on FIF_GL_CROSS_REF table. The reason for failure is Tran Code 93 has rows with tran_ref_no as not null. But check constraint is not handling this data. The script responsible for this operation is "rms/installer/mom14/Financials/db_change_scripts/source/002138_fif_gl_cross_ref.sql"

2. Later the installer was trying to re-execute the following scripts as part of 14.1 upgrade, but all the DDL were already executed as part of earlier versions:
   . Financials/db_change_scripts/source/002286_stage_ext_tran_data.sql
   . Financials/db_change_scripts/source/002287_ext_tran_data_sequence.sql
   . Financials/db_change_scripts/source/002288_gtt_stage_ext_tran_data.sql
   . Financials/db_change_scripts/source/002289_stage_ext_tran_data_chunk.sql

This is causing below various errors like:

 

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