My Oracle Support Banner

ECM Install Stuck (Doc ID 2910375.1)

Last updated on NOVEMBER 24, 2022

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.

Goal

ECM 806 upgrade from ECM 804 is failing.


Below are the observations:

OFS_ECM_LOG.log
------------------------------
While merging various case types data into KDD_CASE_TYPE_SUBTYPE table below
error is observed:

Error:ORA-00904: "CASE_CLASS_ID": invalid identifier

The filed (CASE_CLASS_ID) is missing in the table creation creation script.
PFB table creation script generated as part of case data model.

Create table kdd_case_type_subtype (CASE_TYPE_SUBTYPE_CD VARCHAR2(60 CHAR)
DEFAULT NULL Not Null,CASE_TYPE_CD VARCHAR2(20 CHAR) DEFAULT NULL Not
Null,CASE_TYPE_NM VARCHAR2(100 CHAR) DEFAULT NULL Not Null,CASE_TYPE_DESC
VARCHAR2(150 CHAR) DEFAULT NULL Null,CASE_SUBTYPE_CD VARCHAR2(20 CHAR)
DEFAULT NULL Null,CASE_SUBTYPE_NM VARCHAR2(100 CHAR) DEFAULT NULL
Null,CASE_SUBTYPE_DESC VARCHAR2(150 CHAR) DEFAULT NULL
Null,CASE_CLASSIFICATION_CD VARCHAR2(60 CHAR) DEFAULT NULL
Null,LAST_UPDATED_BY VARCHAR2(20 CHAR) DEFAULT NULL Null,LAST_UPDATED_DT
DATE DEFAULT NULL Null,COMMENTS VARCHAR2(1000 CHAR) DEFAULT NULL
Null,CONSTRAINT PK_992 PRIMARY KEY (CASE_TYPE_SUBTYPE_CD)) TABLESPACE
DATA_CM_TBSP
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.