Encountered Database Error ORA-00904 While Applying MWM 2.1.0.1 Upgrade Patch13716842 (Doc ID 1436723.1)

Last updated on MARCH 15, 2012

Applies to:

Oracle Utilities Mobile Workforce Management - Version: 2.1.0 and later   [Release: 2.1 and later ]
Information in this document applies to any platform.

Goal

while running cdxdbi.exe in ORS/install-upgrade, encountered error:

ERROR: ORA-00904: "CUSTOM_SW": invalid identifier (DBD ERROR: error possibly near <*> indicator at char 89 in 'select CHAR_TYPE_CD, FK_REF_CD, ADHOC_
VAL_ALG_CD, CHAR_TYPE_FLG, SEARCH_FLG, OWNER_FLG, <*>CUSTOM_SW from CI_CHAR_TYPE where OWNER_FLG='M1'') occured while executing select CHAR_TYPE_CD,
FK_REF_CD, ADHOC_VAL_ALG_CD, CHAR_TYPE_FLG, SEARCH_FLG, OWNER_FLG, CUSTOM_SW from CI_CHAR_TYPE where OWNER_FLG='M1'
Error Occured, Process being aborted

Details from the related tables:


SQL> desc cisadm.ci_char_type;

Name Null? Type
-----------------------------------------
CHAR_TYPE_CD     NOT NULL  CHAR(8)
FK_REF_CD        NOT NULL  CHAR(8)
ADHOC_VAL_ALG_CD NOT NULL  CHAR(12)
CHAR_TYPE_FLG    NOT NULL  CHAR(4)
VERSION          NOT NULL  NUMBER(5)
SEARCH_FLG       NOT NULL  CHAR(4)
OWNER_FLG        NOT NULL  CHAR(4)

SQL> select * from cisadm.ci_install_prod;

INSTA OWNE RELEASE_ID COMP UPDATE_DT VERSION SORT_SEQ BUILD_NB
----- ---- -------------------- ---- --------- ---------- ---------- --------
PATCH_NB D PRODUCT_NAME  RELEASE_ID_SFX PROD
--------------------------------------------------------------------------------
11111 F1 V4.1.0 COMP 17-OCT-11 6 98 001
000 N Oracle Utilities Application Framework

11111 CM V0.0.0 COMP 17-OCT-11 2 2 000
000 N Customer Release

11111 M1 V2.1.0 COMP 28-NOV-11 16 90 016
000 Y Oracle Realtime Scheduler

11111 M2 V2.1.0 COMP 28-NOV-11 13 90 016
000 Y Oracle Utilities Mobile Workforce Management

Solution

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