My Oracle Support Banner

E-UPG: PT 8.50 to PT 8.52 Upgrade fails with ORA-00904: "PT_SIGNON_TYPE": invalid identifier on Task: Reviewing PeopleTools Objects (Doc ID 2553068.1)

Last updated on OCTOBER 29, 2019

Applies to:

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

Symptoms

On : 8.52 version, Upgrade

During upgrade PT850-> PT852, an error occurred when running 'Task 4-6 Reviewing PeopleTools Objects'.

ERROR
----------
File: E:\pt85226a-retail\peopletools\src\pssys\stmupd.cppSQL error. Stmt #: 2312 Error Position: 69 Return: 904 - ORA-00904: "PT_SIGNON_TYPE": invalid identifier
Failed SQL stmt:INSERT INTO PSACCESSLOG (OPRID, LOGIPADDRESS, LOGINDTTM, LOGOUTDTTM, PT_SIGNON_TYPE) VALUES (:1, :2, TO_TIMESTAMP(:3,'YYYY-MM-DD-HH24.MI.SS.FF'), TO_TIMESTAMP(:4,'YYYY-MM-DD-HH24.MI.SS.FF'), :5)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the 'Task 4-6 Reviewing PeopleTools Objects'.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.