Upgrade to IP16.17 fails with ORA-00904 while running UPG_DATA_AFTERSEED.SQL

(Doc ID 2331879.1)

Last updated on NOVEMBER 24, 2017

Applies to:

Siebel CRM - Version 16.17 [IP2016] and later
Information in this document applies to any platform.

Symptoms

When attempting to run upgrep from IP13 to IP 16 patchset 17
the following error occurs.

SQLError Statement 0 0000000259f073db:0 2017-10-25 09:51:52 SQL Statement:
UPDATE S_EVT_ACT_CAL SET CAL_SEQ= (SELECT MAX(MAXVAL) FROM (SELECT MAX(R1.CAL_SEQ) AS MAXVAL FROM S_CAL_REPT_EVT R1, S_EVT_ACT A1 WHERE R1.PAR_REPTEVT_MST_ID = A1.APPT_REPT_APPT_ID AND S_EVT_ACT_CAL.PAR_ROW_ID = A1.ROW_ID AND A1.APPT_REPT_REPL_CD = 'UPDATE' UNION SELECT 999 AS MAXVAL FROM S_DUAL) MV1 ) + (SELECT COUNT(1) FROM S_EVT_ACT_CAL C1 WHERE C1.PAR_ROW_ID IN (SELECT ROW_ID FROM S_EVT_ACT WHERE S_EVT_ACT.CAL_TYPE_CD= 'Calendar and Activity' AND APPT_REPT_APPT_ID IS NOT NULL AND APPT_REPT_REPL_CD = 'UPDATE' AND APPT_REPT_END_DT IS NOT NULL) AND NOT EXISTS (SELECT 'X' FROM S_EVT_ACT_CAL T1, S_EVT_ACT T2, S_EVT_ACT T3 WHERE T2.APPT_REPT_APPT_ID = T3.APPT_REPT_APPT_ID AND S_EVT_ACT_CAL.PAR_ROW_ID = T3.ROW_ID AND T1.PAR_ROW_ID = T2.ROW_ID AND T2.APPT_REPT_REPL_CD='DELETE' AND T3.APPT_REPT_REPL_CD='UPDATE' AND T2.TODO_PLAN_START_DT = T3.TODO_PLAN_START_DT) AND C1.ROW_ID<=S_EVT_ACT_CAL.ROW_ID ) WHERE S_EVT_ACT_CAL.PAR_ROW_ID IN (SELECT ROW_ID FROM S_EVT_ACT WHERE S_EVT_ACT.CAL_TYPE_CD= 'Calendar and Activity' AND APPT_REPT_APPT_ID IS NOT NULL AND APPT_REPT_REPL_CD = 'UPDATE' AND APPT_REPT_END_DT IS NOT NULL) AND NOT EXISTS (SELECT 'X' FROM S_EVT_ACT_CAL T1, S_EVT_ACT T2, S_EVT_ACT T3 WHERE T2.APPT_REPT_APPT_ID = T3.APPT_REPT_APPT_ID AND S_EVT_ACT_CAL.PAR_ROW_ID = T3.ROW_ID AND T1.PAR_ROW_ID = T2.ROW_ID AND T2.APPT_REPT_REPL_CD='DELETE' AND T3.APPT_REPT_REPL_CD='UPDATE' AND T2.TODO_PLAN_START_DT = T3.TODO_PLAN_START_DT)

DBCLog DBCLogError 1 0000000259f073db:0 2017-10-25 09:51:52 [1076673536][ODBC Oracle driver][Oracle]ORA-00904: "S_EVT_ACT_CAL"."PAR_ROW_ID": invalid identifier

 
The issue can be reproduced at will with the following steps

1. Install IP16
2. Apply PS 17
3. run upgrade
4. fails with mentioned error

 

 

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