UPD22817588_06_IMP_DMS - ORA-00904: "FIELDNAME": Invalid Identifier Error With PeopleTools 8.55

(Doc ID 2330047.1)

Last updated on NOVEMBER 21, 2017

Applies to:

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

Symptoms

On : CS 9.2 PUM Image 7, Tools 8.55

When attempting to apply maintenance from CS 9.2 PUM Image 7, the following error occurs with the Change Assistant Step "Running data mover Import UPD22817588_06_IMP_DMS":

ERROR
-----------------------
SQL Error. Error Position: 577 Return: 904 - ORA-00904: "FIELDNAME": invalid identifier
INSERT INTO PSPTCSSRVCONF (PORTAL_NAME, PORTAL_OBJNAME, PTCS_SERVICEID, PTCS_INSTANCEID, PTCS_ISCOMPSERVICE, PNLNAME, SEQNUM, PTCS_HIDEFROMSRCH, IS_DEFAULT, PTCS_MAPSECOPTIONS, HANDLERNAME, PTCS_INSTANCELBL, PTCS_URLTARGET, PTCS_RCMENUOPT, PTCS_MAINMENUOPT, PTCS_SEQNUM_MMNU, PTCS_SEQNUM_RMNU, PACKAGEROOT, QUALIFYPATH, APPCLASSID, PTCS_INITMIN, PTCS_ENABLE, PTCS_SRVOPENOPTION, PTCS_EMBEDDABLE, PTCS_SUOWSERV, VERSION, LASTUPDDTTM, LASTUPDOPRID, OBJECTOWNERID, PTCS_SRVCATTR, OPRID, PTCS_MASTERTMPL, RECNAME, PTCS_CMPEVENT, PTCS_PROCSEQ, PTCS_CMPRECEVENT, PTCS_ALLOWPERSONAL, FIELDNAME) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, TO_TIMESTAMP(:27,'YYYY-MM-DD-HH24.MI.SS.FF'), :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38)
Error: Unable to insert row 1
Error: SQL execute error for PSPTCSSRVCONF


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the data mover Import UPD22817588_06_IMP_DMS.


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