My Oracle Support Banner

Fusion OTBI - Incorrect Date When Exporting Analysis To Excel (Doc ID 2348031.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version and later
Oracle Fusion Application Toolkit Cloud Service - Version and later
Information in this document applies to any platform.


Dates are incorrect when exporting analysis to excel. Dates display or have been formatted to display the correct date when viewing via the system. However, when exporting to excel, excel seems to be treating the date as date/time in UTC. Upon formatting the exported data to see the date & time in excel, it displays the prior day 6pm, (the six hour offset to Central time).

Steps to Replicate:
Create analysis with Person Number and Person Hire Date from the Worker folder in the Workforce Management – Worker Assignment Real Time subject area.
Export to Excel.


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.