My Oracle Support Banner

When Upgrading MDM from v2.1 SP3 to 2.2 SP2 (2.1.0.3.0 to 2.2.0.2.0) Instructions Indicate to Drop Column CTXT_VAL That Does Not Exist (Doc ID 2400222.1)

Last updated on JUNE 11, 2018

Applies to:

Oracle Utilities Meter Data Management - Version 2.1.0.3 to 2.2.0.2.0 [Release 2.1 to 2.2]
Information in this document applies to any platform.

Goal

When Upgrading MDM from version 2.1 SP3 (2.1.0.3.0) to 2.2 SP2 (2.2.0.2.0) the instructions in  MDM_DBA_Guide_v2_2_0_2.pdf , Section : "Drop Column from Database" after completing "Installing the Oracle Utilities Application Framework Database Component using OraDBI.jar" were listed:

Connect to CISADM schema through SQL and the drop the following column.
ALTER TABLE CI_XAI_RCVR_CTX DROP COLUMN CTXT_VAL;

After Installing the Oracle Utilities Application Framework Database Component using OraDBI.jar, the above column in the database table did not exist.

Please advise if this already gets dropped by running Installing the Oracle Utilities Application Framework Database Component using OraDBI.jar?
 

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!

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