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)
Last updated on SEPTEMBER 21, 2016
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 18.104.22.168.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 22.214.171.124.0 and later
Oracle Fusion Application Toolkit - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
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.
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