My Oracle Support Banner

Time Zone Value In OAC DV Workbook And Classic Analysis (Doc ID 2913696.1)

Last updated on DECEMBER 08, 2022

Applies to:

Oracle Analytics Cloud - Version September 2022 (6.8) and later
Information in this document applies to any platform.


The following is set for timezone in OAC:

DV > Console > System Settings

Default Data Offset Time Zone is set to 0
Default User Prefered Time Zone is set to  GMT-07:00 Mountain Time
Default Time Zone for Date Calculations is set to Default

OAC Classics > My Account > Preferences is set to Mountain Time.

Anaysis Report in classic and Workbook in DV is not showing up the correct timestamp for the above settings.

The database is UTC.

The requirement is to convert the UTC timezone values in db tables used for reporting(analysis and workbook), to MST.

It does not work.

Using a calculation field CURRENT_TIMESTAMP, shows up the correct value in analysis and workbook.

But if the report and workbook is pulling the data from database tables, then the values are not showing up correctly.

Timezone settings are not effective in OAC.


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

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