My Oracle Support Banner

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

Last updated on FEBRUARY 05, 2021

Applies to:

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

Goal

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?
 

Solution

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
Goal
Solution


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