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.
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
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