My Oracle Support Banner

Maintenance from Campus Solutions 9.2 PUM Image 13 to Target at PUM 3 Fails During Change Assistant Step (Doc ID 2565424.1)

Last updated on JUNE 25, 2021

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

An error occurs when using Campus Solutions 9.2 PUM 13, PeopleTools 8.57.04 as source, and a target Campus Solutions 9.2 at PUM 3, PeopleTools 8.55.

The error received during the change assistant step, when running DataMover Import upd23598430_01_imp_dms.

Error received is:

SQL Error. Error Position: 920 Return: 904 - ORA-00904: "PTAI_CTX_METHOD": invalid identifier
INSERT INTO PS_PTAI_LIST (PTAI_LIST_ID, PORTAL_NAME, PTAI_LABEL, PTAI_DESCRLONG, PTAI_NOTIFY_TYPE, PTAI_AGRENDERTYPE, PTAI_RESTARTAG, PTAI_SUOW, PTAI_ACTIVE_FLG, CREATED_DTTM, CREATEOPRID, LAST_UPDATE_DTTM, LASTUPDOPRID, OBJECTOWNERID, PTAI_IS_TMPL, PTAI_PARENT_TMPL, PTAI_LIST_STATUS, PACKAGEROOT, QUALIFYPATH, APPCLASSID, APPCLASSMETHOD, PTAI_INST_PKGROOT, PTAI_INST_QUALPATH, PTAI_INST_CLASSID, URL, PTAI_REOPEN_ITEM, PTAI_PGLT_EXCL, PTAI_FIELD1_LBL, PTAI_FIELD2_LBL, PTAI_FIELD3_LBL, PTAI_FIELD4_LBL, PTAI_FIELD5_LBL, PTAI_FIELD6_LBL, PTAI_FIELD7_LBL, PTAI_FIELD8_LBL, PTAI_FIELD9_LBL, PTAI_FIELD10_LBL, PTAI_PGLT_EXIT, PTAI_PREPROC_METH, PTAI_PGLT_SAVE, PTAI_INST_PROC, PTAI_PBVISIBLE, PTAI_START_DT, PTAI_DUE_DATE, PTAI_GPDS_ID, PTAI_SINGLECOMPAG, PTAI_FIXEDSIDEPNL, PTAI_SHOWFLNOTIFY, PTAI_QUESTIONNAIRE, PTAI_SYSTEM_DATA, STYLESHEETNAME, PTAI_CTX_DISP_OPT, PTAI_CTX_PKGROOT, PTAI_CTX_QUALPATH, PTAI_CTX_CLASSID, PTAI_CTX_METHOD) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, TO_TIMESTAMP(:10,'YYYY-MM-DD-HH24.MI.SS.FF'), :11, TO_TIM...
Error: Unable to insert row 1
Error: SQL execute error for PTAI_LIST

PeopleSoft Enterprise Campus Solutions Community  Support Blog  Information_Centers  Maintenance_Advisor 

 

 

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
References


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