OBIA 11g - Upgrade Load Plan Failed on W_SALES_CYCLE Tables with Error "ORA-01758: table must be empty to add mandatory (NOT NULL) column" (Doc ID 1959752.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 to 11.1.1.8.1 [Release 11g]
Information in this document applies to any platform.

Symptoms

While upgrading an  OBIA environment from OBIA 11.1.1.7.1 to OBIA 11.1.1.8.1 using <Note 1673221.1:> Oracle BI Applications 11.1.1.7.1 -> 11.1.1.8.1 Upgrade Guide, the Upgrade Load Plan failed on W_SALES_CYCLE Tables with the following Errors:


Error 01:
Running DDLs
Error running
 ALTER TABLE DEV_DW.W_SALES_CYCLE_HEADER_F_TMP ADD (ETL_PROC_WID NUMBER(10) NOT NULL)
  (<type 'java.sql.SQLSyntaxErrorException'> - java.sql.SQLSyntaxErrorException: ORA-01758: table must be empty to add mandatory (NOT NULL) column)

Error 02:
Error running
 ALTER TABLE DEV_DW.W_SALES_CYCLE_LINE_F_TMP ADD (ETL_PROC_WID NUMBER(10) NOT NULL)
  (<type 'java.sql.SQLSyntaxErrorException'> - java.sql.SQLSyntaxErrorException: ORA-01758: table must be empty to add mandatory (NOT NULL) column)


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