nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

FDI vs. OAC: Time Zone in Workbooks Preview Feature

Carter Beaton

There is a new time zone feature that came out as an OAC preview feature in the November release. This feature allows the user to override the default time zone and shows timestamp data in their time zone instead of the default. Useful when you have data produced in GMT time and user in Eastern time.

This feature can be turned on in OAC Advanced Settings in the console, but in FDI the option is not available in System Settings for their November release. Nor is it a FDI Feature or as a SM Extension. There are preview features and time options available in FDI System Settings, so why not this one? The FDI OAC About references the same documentation as OAC and the docs don't exclude FDI.

Is there any reason why this is not available? Or is turn on elsewhere in FDI?

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/time-zones-preview.html

Find more posts tagged with

FDI

OAC

FAIDP

Accepted answers

All comments

Steve F-2

The FDI OAC may not be at the same update level. Typically FDI features will be updated in the FDI "What's New" documentation.

I will move this to the FDI forum, since it is not an OAC question.

Dhaval Parikh Stantec

@SteveF-Oracle Will this feature be added in OAS 2026 DV?

RVohra

As per my experience, it is not necessary that if a feature is available in OAC, it will be available in FDI as well.

Reason is FDI must stay aligned with Fusion application semantics. Fusion Applications store and process timestamps in application-defined time zones. It already apply time zone logic consistently across:

Transactions
- OTBI
- ESS jobs
- BICC extracts

If Oracle allowed per-user time zone overrides in FDI:

Two users could see different dates for the same transaction
KPIs like “Daily Revenue”, “Aging”, “Backlog” would no longer reconcile with Fusion UI
Oracle Support would lose a single source of truth

It will break one of FDI’s main promises: analytics must reconcile with Fusion.

Hope it helps!

Carter Beaton

@SteveF-Oracle Thank you for moving it over the FDI forum

@RVohra Thank you for your comment. The main issue here is that the transactions have a GMT timestamp and when users on the East Coast view the transactions that are stamped after 7pm eastern they don't show because of the time difference even though they have the same date. The new option in OAC for a user to change their timestamp fixes this issue.

Steve F-2

I believe you still have the options available to you prior to this preview feature for a user to override in their profile.

Administrators can also configure additional time zone system settings in the Console to apply a default time zones to users.

Default Data Offset Time Zone
Default Time Zone for Date Calculations
Default User Preferred Time Zone

TIMESTAMPADD function is also documented.

Dhaval Parikh Stantec

@SteveF-Oracle Sorry, so how is this preview feature different than what we already have in the current OAS version?

Steve F-2

@Dhaval Parikh Stantec
The preview feature for non-FDI OAC is documented here:

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/time-zones-preview.html
and
https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/set-your-preferred-time-zone-preview.html#ACUBI-GUID-C4F812AA-760E-4BC5-A47E-9A5E2C46C7CD

The feature is not included in OAS 2025 or earlier.

Carter Beaton

@SteveF-Oracle

Thank you again Steve.

The client is global so we cannot use the default settings and the client does not wish to modify the workbooks using calculations.

So I guess the question is now posed to FDI product managers: Will this feature be implemented in FDI?