My Oracle Support Banner

How to Convert RTF to A Timezone When Data Model Is Analysis (Doc ID 2750265.1)

Last updated on APRIL 25, 2022

Applies to:

Oracle Fusion CX Sales Cloud Service - Version and later
Oracle Fusion B2B Service Cloud Service - Version and later
Information in this document applies to any platform.


For this example, we are creating an analysis based on "Sales - CRM Pipeline" subject area and expose Opportunity Create Date = 09/20/2017 3:27:12 PM.

When creating a data model based on the analysis created, the sample XML shows that field is passed in UTC: 2017-09-20T21:27:12 so when the BIP report is created, it is showing the time in UTC (date is not converted to GMT-0300 as expected).

How to convert the date/time field to the proper timezone when data model source is an analysis?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.