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

Last updated on NOVEMBER 03, 2023

Applies to:

Goal

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.

Solution

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