You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Fusion BI Report Time zone issues in report output related queries

Accepted answer
56
Views
5
Comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!