My Oracle Support Banner

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

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle Utilities Mobile Workforce Management - Version 2.1.0 and later
Information in this document applies to any platform.

Goal

While running cdxdbi.exe in Oracle Real-Time Scheduler (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:


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
References


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