Our users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries before we proceed to update all the report code. * Parameters have an option whether to be input in UTC using the ignore timezone flag. So if the “ignore time zone” option is checked then no date conversions are needed is what we assume. Is this correct? * Similarly internal sysdate and current_date are in UTC and when comparing with other table date fields which are all in UTC, so we believe we don’t need a date conversion in such cases. * All date conversions in where clause impact report performance. * Will all these TZ conversion modified report outputs be in sync with system/standard report outputs? Does standard reports display based on timezone preferences? * How do we take care of Dates on OTBI/FRS reports for timezone related updates? Thanks Abhilash

Oracle Communities

Oracle Analytics and AI

Child Item

Queries on Timezone related outputs in ERP Cloud

Our users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries before we proceed to update all the report code.

Parameters have an option whether to be input in UTC using the ignore timezone flag. So if the “ignore time zone” option is checked then no date conversions are needed is what we assume. Is this correct?
Similarly internal sysdate and current_date are in UTC and when comparing with other table date fields which are all in UTC, so we believe we don’t need a date conversion in such cases.
All date conversions in where clause impact report performance.
Will all these TZ conversion modified report outputs be in sync with system/standard report outputs? Does standard reports display based on timezone preferences?
How do we take care of Dates on OTBI/FRS reports for timezone related updates?

Thanks

Abhilash

Find more posts tagged with

BI Publisher

BI Publisher Data Models

OTBI

Report Output

Accepted answers

Abhilash K - Deloitte USI

We decided to modify the query with conversion of the timestamp columns so we reduce the load of the post processor. thanks all.

All comments

User_0GPX5

Hi @Renuka Nuguru-Oracle : Do we have function to convert the time to PST which handles the daylight saving automatically for BIP reports ?

Vanitha Kundaram

We did try to use Transformation clause in where clause of our BIP report query and scheduling the report on required Timezone, but it still does not pull data as required.
Any breakthrough in getting the records as on required Timezone ?