My Oracle Support Banner

ToFacilityDateTime() Not Working (Doc ID 2446393.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Warehouse Management Business Intelligence Cloud Service - Version 9.0.0 and later
Information in this document applies to any platform.

Goal

On : NA version, BI Core Functionality

ToFacilityDateTime() not working

In Webreports ToFacilityDateTime() not working.

In our example below, for facility, CTX1 the timezone is CST and we are comparing LPN creation timetamp between IB LPN and corresponding web report.
The function ToFacilityDateTime({Inventory.Create Timestamp}) is being used.

Taking LPN 00000722400000600883 for CTX1
IB LPN Create Time Stamp --> 08/04/2018 8:43:08 PM
Web Reports Create Time Stamp --> 08/05/2018 1:43:08 AM

The web report is already using the function to convert the time stamp to Facility Time; but still its not converting to show the time in facility time-zone but UTC.

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.