E-INST: Unable To Sign On To PIA After Fresh Installation (Doc ID 1427984.1)

Last updated on JULY 25, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.52 and later
Information in this document applies to any platform.
** Currency checked Dec 2013 ***
** Currency checked Sept 2013 ***

Symptoms

ENVIRONMENT
==============

PeopleTools 8.52

PeopleSoft Application: any PeopleSoft Application that was released on a lower version than 8.52.
e.g FSCM 9.1 on PT 8.52 or HRMS 9.1 FP March 2010 on PT 8.52

When attempting to signon into PIA page, the following error is seen:

ERROR
-----------
"Portal database setup is incomplete. A local node has not been defined. Please contact your system administrator.".
 
In Application Server Log the following error is seen:
 
ERROR
-----------
Return: 904 - ORA-00904: "IB_NETWORK": invalid identifier
 
Failed SQL stmt:SELECT TO_CHAR(CAST((LASTUPDDTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'), LASTUPDOPRID, VERSION, LOCALNODE, IB_SEGMENTAWARE, NONREPUDIATION, IB_DEFLTEXTUSERID, IB_TGTLOCATION, TOOLSREL, APMSGAPPREL, ACTIVE_NODE, LOCALDEFAULTFLG, NODE_TYPE, PORTAL_NAME, ROUTINGTYPE, AUTHOPTN, IBPASSWORD, USERID, IBEXTERNALUSERID, IBEXTERNALPWD, IBEXTERNALVERSION, IB_THROTTLEVALUE, HUBNODENAME, MASTERNODENAME, IMAGE_NAME, CODESETGROUPNAME, CONNGATEWAYID, CONNID, COMPANYID, CONTACTMNGR, CONTACTEMAIL, CONTACTPHONENBR, CONTACTURL, DESCR, TOKENTYPE, WSRP_RESP_WSS, TOKEN_ENCRYPTED, IB_ENCRYPTLEVEL, TOKEN_SIGNED, IB_DELIVERYMODE, IB_NETWORK, DESCRLONG FROM PSMSGNODEDEFN WHERE MSGNODENAME = :1
PSAPPSRV.5500 (1) [02/29/12 17:25:32 GetCertificate](3) Generating an invalid authentication token:  No local Message Node defined for this system.  Open a Message Node Definition and mark it -Local- on the properties page
PSAPPSRV.5500 (1) [02/29/12 17:25:32 GetCertificate](1) VerifyGlobalTokenEqualsContext (SD) failed:  AuthToken is still NULL! 

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