My Oracle Support Banner

E-OS: Copy PPLTLS860 Project Fails During Upgrade -- 'SYSADM.SFA_PSPRSMDEFN_TR' Is Invalid And Failed Re-validation (Doc ID 3002198.1)

Last updated on FEBRUARY 05, 2024

Applies to:

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

Symptoms

Copy PPLTLS860 Project fails during PeopleTools upgrade to 8.61 with the below error on the screen:


/***********************************************************************************************/


Portal Registry Structures Application Upgrade Copy started: 2024-01-24-12.37.59
File: <UPGRADE_HOME_FOLDER>\peopletools\src\psmgr\mgrgensql.cppSQL error. Stmt #: 1653 Error Position: 12 Return: 4098 - ORA-04098: trigger 'SYSADM.SFA_PSPRSMDEFN_TR' is invalid and failed re-validation
Failed SQL stmt: DELETE FROM PSPRSMDEFN WHERE PORTAL_NAME = :1 AND PORTAL_REFTYPE = :2 AND PORTAL_OBJNAME = :3

 

/***********************************************************************************************/

 



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


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