E-UPG: Updating the Product License Code Script Fails: PTENCRYPTADSPRJFLE invalid identifier error

(Doc ID 2148393.1)

Last updated on JUNE 10, 2016

Applies to:

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

Symptoms

On : 8.55 version, Upgrade

"Updating the Product License Code" script fails with following error in HCM91 to HCM92 upgrade;


ERROR
-----------------------
Started: Thu May 19 21:09:02 2016
Data Mover Release: 8.55.04
Database: DPDEV92 (ENG)
Indexing export file E:\PT8.55\Data\pt_installdata.dat
Input file: E:\PT8.55\Data\pt_installdata.dat (ENG)
Commit done at end of record
Importing PSOPTIONS_TMP
SQL Error. Error Position: 1163 Return: 904 - ORA-00904: "PTENCRYPTADSPRJFLE": invalid identifier
INSERT INTO PSOPTIONS_TMP (MULTIJOB, SYSTEMTYPE, SHORTNAME, LONGNAME, MULTICOMPANY, LANGUAGE_CD, HELP_CONTEXT_LAST, MULTICURRENCY, GRANT_ACCESS, STATS_GATHER, STATS_TABLE, STATS_TIMER, STATS_START, STATS_STOP, NVSUSEBUSUNIT, BACKGRNDDISCINT, CHGCTL_USE_HISTORY, CHGCTL_USE_LOCKING, TRANS_CHG_LASTUPD, DBLENGTHTYPE, TEMPTBLINSTANCES, TEMPINSTANCEBATCH, TEMPINSTANCEONLINE, AEOPTTRC, APMSGMAXMSGSIZE, MAXCHUNKSIZE, IBMAXNBRSEGMENTS, BSE_TIMEZONE, CASEINSSEARCH, STYLESHEETNAME, ICLIENTURL, LICENSE_CODE, LICENSE_GROUP, TIMEOUTMINUTES, OPRID, AUTHTOKENTYPE, COLLATION_TYPE, PLATCOMPAT, DB2ALLCCSIDOK, COMMITLIMIT, PACKAGEROOT, APPCLASSID, USETREELOCKING, TREEINACTIVITY_PER, GUID, NVSUSESECREPRQST, ICEURL, MAINTLOG_VALID, SAVEERRORISFATAL, PCODEWIP, F1URL, CTRLF1URL, PSSDWENABLED, PTENABLESWITCHUSER, PTSVBTNFOCUS, PTNEWSAVEWARNING, WSRPDISPMODE, MAXSRCH, DFLTSEARCH, PTDFLTSESSEARCH, SCROLLABLEGRID, PT_TDE_ENCRYPT_ALG, PT_USE_FTPLIB, PRJCOMMIT, PT_ALIGN_RT, HEADERPAGENAME, SEARCHRESPAGENAME, FOOTERPAGENAME, SIDEPAGENAME, PROMPTPAGENAME...
Error: Unable to insert row 1
Error: SQL execute error for PSOPTIONS_TMP
Ended: Thu May 19 21:09:02 2016
Unsuccessful completion


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run "Updating the Product License Code" step

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot continue with the upgrade

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