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 How to set timezone for FDI records to match timezone of NetSuite records

FAW_User-Oracle

Customer's company runs under the Eastern US time zone and all of the data in Netsuite is a date/time type of data and it is viewed on the records in Eastern US time.

Customer wants the NSAW timezone to be Eastern US Time the same with their Netsuite timezone to be able to have more accurate data usage of their reports and dashboards in NSAW

Find more posts tagged with

Delivered

FDI

NSAW

timezone

Status: Delivered

Comments

Sumanth V -Oracle

@FAW_User-Oracle - Welcome to the Oracle Community!

The timezones are set to UTC in Fusion Analytics as the default timezone is set to UTC in the Autonomous Data Warehouse.

The Autonomous Data Warehouse timezone can be confirmed by executing the below SQL query on clients like SQL Developer, Toad, etc.:

SELECT dbtimezone FROM DUAL;

The output could be something like +00:00, which indicates it is UTC.

Reference:
What Is The Default Timezone In FAW and How Can It Be Changed? (KB102471)

We encourage you to continue using the Oracle Community to explore more such topics and share your experiences!