Fusion Financials General Ledger - Essbase Export to Excel does incorrect auto conversion of the Calendar month name column header, based on the data input of a month number (Doc ID 1931275.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Fusion Application Toolkit Cloud Service - Version 11.1.8.0.0 and later
Oracle Fusion General Ledger - Version 11.1.8.0.0 and later
Oracle Fusion Application Toolkit - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Symptoms

Fusion Financials 11.1.8 - Inquire and Analyze Balances



Steps
--------

A financial calendar "My Calendar" has been set up. starts in April and Month 10 is January

Display Balances from the Inquire and Analyze Balances screen Account Inspector

Measure column header is  "All GFR values 10-2012" it shows data value 0.00

Export to Excel, column header title reads  "All GFR values Oct-2012"  data value is correct at 0.00

Conclusion data is correct, BUT the column heading in Excel has been interpreted incorrectly ie month 10 incorrectly translates for this Fiscal Calendar to October in Excel

Excel version : 2007 12.0.6683.5002 SP3 MSO
Notes: Unable to export to pdf there is no option to test it

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