Upgrade From 12.2.5 To 12.2.6\12.2.7 Failing With ORA-00904 And ORA-01418 Errors
(Doc ID 2969485.1)
Last updated on AUGUST 22, 2023
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.2.6 to 12.2.7 [Release 12.2]Information in this document applies to any platform.
Symptoms
While upgrading from 12.2.5 to 12.2.6, patch# 22115675 - R12.SCP_PF.C.DELTA.7 is failing at ADOP phase with below error:
Drop query is DROP INDEX MSC."MSC~DEMANDS~N12"
Error in executing statement: CREATE INDEX "MSC"."MSC~DEMANDS~N12" ON "MSC"."MSC_DEMANDS" ("PLAN_ID", "ORDER_NUMBER", "ORIGINATION_TYPE")
PCTFREE 10 INITRANS 11 MAXTRANS 255
STORAGE(
BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_TX_IDX" LOCAL
( PARTITION DEMANDS__2021 TABLESPACE APPS_TS_TX_IDX ,
PARTITION DEMANDS_0 TABLESPACE APPS_TS_TX_IDX ,
PARTITION DEMANDS_5 TABLESPACE APPS_TS_TX_IDX ,
PARTITION DEMANDS_2021 TABLESPACE APPS_TS_TX_IDX ,
PARTITION DEMANDS_2022 TABLESPACE APPS_TS_TX_IDX ,
PARTITION DEMANDS_3025 TABLESPACE APPS_TS_TX_IDX ,
PARTITION DEMANDS_3027 TABLESPACE APPS_TS_TX_IDX ,
PARTITION DEMANDS_3028 TABLESPACE APPS_TS_TX_IDX ,
PARTITION DEMANDS_3029 TABLESPACE APPS_TS_TX_IDX ,
PARTITION DEMANDS_4026 TABLESPACE APPS_TS_TX_IDX ,
PARTITION DEMANDS_4027 TABLESPACE APPS_TS_TX_IDX ) PARALLEL ONLINE NOLOGGING
Error message is: ORA-00904: "ORDER_NUMBER": invalid identifier
Error in executing statement: ALTER INDEX MSC."MSC~DEMANDS~N12" NOPARALLEL LOGGING
Error message is: ORA-01418: specified index does not exist
Changes
Upgrade from 12.2.5 to 12.2.6
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |