WebCenter Analytics Storing Records with Different Date/Time than the Local Time
(Doc ID 1584112.1)
Last updated on SEPTEMBER 26, 2023
Applies to:Oracle WebCenter Portal - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 11g]
Information in this document applies to any platform.
In the ACTIVITIES scheme ANALYTICS records are stored in GMT and not the actual local time.
Clicking around a WebCenter Portal application at 13:51 hours where the weblogic managed server is running with this option: -Duser.timezone=Europe/Amsterdam. Then doing this query :
Get this output :
Pages 2013-10-09 11:51:42
Logins 2013-10-09 11:51:48
Wikis/Blogs 2013-10-09 11:51:47
The "select sysdate from dual" on the database returns the correct time.
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