Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Queries on Timezone related outputs in ERP Cloud

Accepted answer
704
Views
12
Comments
2»

Answers

  • User_0GPX5
    User_0GPX5 Rank 2 - Community Beginner

    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
    Vanitha Kundaram Rank 2 - Community Beginner

    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 ?