E-AS/PIA/AE/PRCS: Seeing EST Timestamp (3 Hours Ahead) Instead Of Using PST Timezone on PeopleSoft Process
(Doc ID 2506888.1)
Last updated on OCTOBER 21, 2022
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.51 and laterInformation in this document applies to any platform.
Symptoms
We are seeing the EST timestamp (3 hours ahead) instead of PST from PeopleSoft. Checked the database but it has the correct timezone settings.
Result from the database:
SELECT DBTIMEZONE, SESSIONTIMEZONE, SYSTIMESTAMP FROM DUAL;
DBTIME SESSIONTIMEZONE SYSTIMESTAMP
------ ---------------------------------------------------------------------------
+00:00 -08:00 12-FEB-19 11.56.39.701495 AM -08:00
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 |