RMS Database 14.0.1 to 14.1 Upgrade Fails With "ORA-00955" Error
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.
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:
This is causing below various errors like:
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