My Oracle Support Banner

Upgrep Dev Failed With ORA-00984 & ORA-06550 Errors On RUN_SQL_280 Execution (Doc ID 2448099.1)

Last updated on NOVEMBER 21, 2019

Applies to:

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

Symptoms

 When running upgrep_dev from 8.1.1.10 to IP2016 the execution failed with the following error:

SQLError Statement 0 000000025b9a0904:0 2018-09-13 17:27:49 SQL Statement:
 DECLARE   CURSOR cur_evt_act IS   SELECT   ROW_ID,   TODO_PLAN_START_DT,   TODO_PLAN_END_DT,   APPT_REPT_END_DT   FROM S_EVT_ACT WHERE   CAL_TYPE_CD='Calendar and Activities'   AND APPT_REPT_FLG = 'Y'   AND APPT_REPT_TYPE= 'Daily'   AND APPT_REPT_END_DT IS NOT NULL   AND APPT_REPT_APPT_ID IS NULL   AND NOT EXISTS (SELECT 'x' FROM S_CAL_REPT_EVT WHERE   PAR_REPTEVT_MST_ID=S_EVT_ACT.ROW_ID AND REI_TS=S_EVT_ACT.TODO_PLAN_START_DT);   cSeq NUMBER;   c_row_id S_EVT_ACT.ROW_ID%TYPE;   c_todo_plan_start_dt S_EVT_ACT.TODO_PLAN_START_DT%TYPE;   c_todo_plan_end_dt S_EVT_ACT.TODO_PLAN_END_DT%TYPE;   c_appt_rept_end_dt S_EVT_ACT.APPT_REPT_END_DT%TYPE;   rei_start_dt S_EVT_ACT.TODO_PLAN_START_DT%TYPE;   c_last_rei_ts S_EVT_ACT.TODO_PLAN_END_DT%TYPE;  BEGIN   OPEN cur_evt_act;   LOOP   FETCH cur_evt_act into   c_row_id,   c_todo_plan_start_dt,   c_todo_plan_end_dt,   c_appt_rept_end_dt;   EXIT WHEN cur_evt_act%NOTFOUND;   cSeq := 0;   WHILE c_todo_plan_start_dt + cSeq <= c_appt_rept_end_dt LOOP   rei_start_dt := c_todo_plan_start_dt + cSeq;   UPDATE S_EVT_ACT_CAL SET CAL_SEQ=cSeq+1, PAR_REPTEVT_MST_ID=c_row_id WHERE PAR_ROW_ID IN   (SELECT ROW_ID FROM S_EVT_ACT  WHERE APPT_REPT_APPT_ID=c_row_id AND TODO_PLAN_START_DT=rei_start_dt AND APPT_REPT_REPL_CD = 'DELETE');   IF SQL%ROWCOUNT = 0 THEN   c_last_rei_ts := c_todo_plan_end_dt+cSeq;   INSERT INTO S_CAL_REPT_EVT(ROW_ID,CREATED,CREATED_BY,LAST_UPD,LAST_UPD_BY,DB_LAST_UPD,DB_LAST_UPD_SRC,CAL_SEQ,PARENT_ACTIVITY_ID,PAR_REPTEVT_MST_ID,REI_TS,REI_END_TS)   VALUES(S_SEQUENCE_PKG.GET_NEXT_ROWID,SYSDATE,'0-1',SYSDATE,'0-1',SYSDATE,'DataMigration',cSeq+1,c_row_id,c_row_id,rei_start_dt,c_last_rei_ts);   END IF;   cSeq := cSeq +1;   END LOOP;   UPDATE S_EVT_ACT_CAL SET LAST_REI_TS=c_last_rei_ts WHERE PAR_ROW_ID=c_row_id;   END LOOP;  END;

DBCLog DBCLogError 1 000000025b9a0904:0 2018-09-13 17:27:49 [tp][ODBC Oracle driver][Oracle]ORA-06550: line 1, column 1578:
PL/SQL: ORA-00984: column not allowed here
ORA-06550: line 1, column 1384:
PL/SQL: SQL Statement ignored

Changes

 

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


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