Fusion Applications BI Publisher : Date information is being transposed when an HCM Extract is run and output is generated to Excel (for example 4712-12-31 showing as 21-Jan-4713) (Doc ID 2065705.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

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

Symptoms

When running an HCM Extract and generating output to Excel some dates that are displayed in the output appear to have had characters transposed when compared to the output from the Extract itself.

For example :

When a given date is viewed in the XML generated by the HCM Extract it shows as '4712-12-31', however when this is output to Excel it is showing as 21-Jan-4713.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms