Customer Connect Announcements

Get Involved. Join the Conversation.

Announcement

    Suzanne Miller
    Working with Time Zones in Oracle BI Publisher White paper
    Announcement posted August 11, 2014 by Suzanne MillerRed Ribbon: 250+ Points, tagged Architecture, BI, Engagement Cloud, Enterprise Planning, Financials, General, HCM, PPM, Procurement, SCM 
    824 Views, 3 Comments
    Title:
    Working with Time Zones in Oracle BI Publisher White paper
    Abstract:

    Introducing:  Working with Time Zones in Oracle BI Publisher White Paper

    Announcement:

    This white paper provides an overview of the time zone settings that impact the value of date time fields, and simple instructions to implement the different reporting scenarios in Oracle BI Publisher reports.

    The PDF is attached to this post, and the PDF can also be accessed through support.oracle.com at ID 1910385.1.       

    This white paper describes the following time zone features in Oracle BI Publisher Reports:

    • Time Zones in Oracle BI Publisher Reports: Simple instructions to implement the different reporting scenarios in Oracle BI Publisher reports without the need to understand the time zone settings and how they impact the values reported.
       
    • Time Zone Settings in Oracle BI Publisher Reports: An overview of the time zone settings that impact the value of date time fields in different Oracle BI Publisher reporting scenarios.
       
    • Time Zones Treatment in Oracle BI Publisher Reports: Different reporting scenarios that highlight the impact of time zone settings in Oracle BI Publisher Reports.

     

    Please let us know if this was helpful!

    Comment

     

    • Kumaran Raviprakash

      This post was really helpful in customers on how to manage timezone variations in their report output.

    • Piyush Mohapatra

      Thanks for Sharing. Helpful indeed!

    • Winke Wieers

      When using the current time field in Word on an RTF-file, the wrong time is shown on the BI Publisher report (2 hours difference in summer time, 1 hour difference in winter time, compared to the actual time)

      Managed to solve the problem with a custom field in Word:
      <?xdoxslt:current_time($_XDOLOCALE,'CET')?>

      CET = Central European Time

      More info: https://blogs.oracle.com/xmlpublisher/date-functions