Fatal Error When Installing 10.14.2.4: DWH_M4146_02.sql: REF-01634 (Doc ID 2018319.1)

Last updated on MARCH 09, 2017

Applies to:

Oracle Health Insurance Claims Management Data Marts - Version 10.14.2.4 and later
Information in this document applies to any platform.

Symptoms

On ACCEPTANCE: 10.14.2.4 version, Installation

When attempting to Install DWH_M4146_02.sql , version 4.1,
the following error occurs.

ERROR
-----------------------
START: Install DWH_M4146_02.sql , version 4.1

INFO : This script updates new columns DM_TABEL_GENERIEK and DM_KOLOM_GENERIEK
  in OHI Back Office table REF_SELECTIE_EIGENSCHAPPEN.
ERROR: Fatal error occurred. Contact Oracle Health Insurance
  ORA-20998: Transactie mislukt - 1 melding(en)! Eerste melding: REF-
  01634: Per GEBRUIK GROEP mag iedere combinatie van DATA MART TABEL
  GENERIEK en DATA MART KOLOM GENERIEK maar één keer gebruikt worden. (GGZ,
  Begindatum prestatie, 01-01-2012).
ORA-06512: at
  "OZG_OWNER.SYS_MESSAGE_UTIL_PCK", line 2181
ORA-06512: at
  "OZG_OWNER.QMS_TRANSACTION_MGT", line 1783
ORA-06512: at
  "OZG_OWNER.CG$AUS_REF_SELECTIE_EIGENSCHAP", line 139
ORA-04088: error
  during execution of trigger 'OZG_OWNER.CG$AUS_REF_SELECTIE_EIGENSCH ORA-
  06512: at line 30



BUSINESS IMPACT
-----------------------
Due to this issue, customer cannot install this release. Customer wants to upgrade OHI Back Office end of month.

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