My Oracle Support Banner

E-AS: SYS Value is not Greater or Equal to all other Values in PSVERSION Table (Doc ID 655237.1)

Last updated on JANUARY 03, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.1 to 8.53 [Release 8.1 to 8.4]
Information in this document applies to any platform.

Symptoms

Running a SYSAUDIT report returned errors in section "Version Checks Audit". PeopleBooks recommends to run VERSION AE in such a case. After running VERSION AE following the procedure described in:
E-AS: How to Run AE VERSION (Application Engine Program) (Doc ID 611565.1)
The SYSAUDIT is clean but running the query:

"SELECT * FROM PSVERSION ORDER BY VERSION DESC;"


against the database then it can be noticed that the version value associated with SYS is no longer greater to or equal to all other values in the PSVERSION table

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