My Oracle Support Banner

E-SEC: What are the Implications in Updating PSVERSION Record Through SQL Statements (Doc ID 2780203.1)

Last updated on MAY 30, 2021

Applies to:

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

Goal

A. What will be the impact of running the below SQL statements in Production environment.
B. Does required downtime in Production environment?
C. What are the maintenance activities (if any) to be performed after the execution of the sql statements.


UPDATE PSVERSION SET VERSION = VERSION + 1 WHERE OBJECTTYPENAME = 'SYS';
UPDATE PSVERSION SET VERSION = VERSION + 1 WHERE OBJECTTYPENAME = 'PPC';
UPDATE PSVERSION SET VERSION = VERSION + 1 WHERE OBJECTTYPENAME = 'PSC';

UPDATE PSLOCK SET VERSION = (SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'PPC') WHERE OBJECTTYPENAME = 'PPC';
UPDATE PSLOCK SET VERSION = (SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'PSC') WHERE OBJECTTYPENAME = 'PSC';

UPDATE PS_PRCSDEFN SET VERSION = (SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'PPC');
UPDATE PS_PRCSJOBDEFN SET VERSION = (SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'PPC');
UPDATE PS_SCHDLDEFN SET VERSION = (SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'PSC');
 

Solution

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
Goal
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.