E-UPG: When Attempting to run the Step Copying the PPLTLS84CUR Project - "System Error : File: E:\pt85609d-retail\peopletools\src\pssys\gensql.cppSQL error. Stmt #: 1517 Error Position: 857 Return: 904 - ORA-00904: "PTMINHASHTYPE": invalid identifier"

(Doc ID 2419655.1)

Last updated on JULY 05, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.56 and later
Information in this document applies to any platform.

Symptoms

On : 8.56 version, PeopleTools Upgrade,

When attempting to run the step Copying the PPLTLS84CUR Project,
the following error occurs.

ERROR
-----------------------
System Error : File: E:\pt85609d-retail\peopletools\src\pssys\gensql.cppSQL error. Stmt #: 1517 Error Position: 857 Return: 904 - ORA-00904: "PTMINHASHTYPE": invalid identifier
Failed SQL stmt: SELECT DBLENGTHTYPE,LANGUAGE_CD,MULTICURRENCY,MULTIJOB,MULTICOMPANY,HELP_CONTEXT_LAST,GRANT_ACCESS,NVSUSEBUSUNIT,BACKGRNDDISCINT,CHGCTL_USE_HISTORY,CHGCTL_USE_LOCKING,TEMPTBLINSTANCES,TEMPINSTANCEBATCH,TEMPINSTANCEONLINE,AEOPTTRC,APMSGMAXMSGSIZE,BSE_TIMEZONE,CASEINSSEARCH,STATS_GATHER,STATS_TABLE,STATS_TIMER,STATS_START,STATS_STOP,STYLESHEETNAME,F1URL,CTRLF1URL,TIMEOUTMINUTES,OPRID,AUTHTOKENTYPE,COLLATION_TYPE,PLATCOMPAT,COMMITLIMIT,USETREELOCKING,TREEINACTIVITY_PER,NVSUSESECREPRQST,SAVEERRORISFATAL,ICEURL,PCODEWIP,PSSDWENABLED,PTENABLESWITCHUSER,PTSVBTNFOCUS,WSRPDISPMODE,MAXSRCH,DFLTSEARCH,PTDFLTSESSEARCH,SCROLLABLEGRID,IBMAXNBRSEGMENTS,PRJCOMMIT,PT_ALIGN_RT,THEMESTYLENAME,LAYOUTSTYLENAME,HEADERPAGENAME,FOOTERPAGENAME,SIDEPAGENAME,SEARCHRESPAGENAME,THEMESTYLETYPE,PROMPTPAGENAME,PTNEWSAVEWARNING,PTRAFLATMENU,PTRAFLATTHRESHOLD,PTENCRYPTADSPRJFLE,PTMINHASHTYPE FROM PSOPTIONS

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Perform the upgrade up to the step Copying the PPLTLS84CUR Project


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