Fusion Financial Reporting - Export from Hyperion FR To Excel 2010 causes loss of numeric formatting, the format is changed to Generic (text) - it should be Numeric (Doc ID 1950249.1)

Last updated on APRIL 29, 2015

Applies to:

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

Symptoms

Oracle Fusion Financials 11.1.8 - Hyperion Financial Reports - Export to Excel 2010 loses the numeric formatting

This worked well in 11.1.3 but after upgrade to 11.1.8 the behavior was encountered.

Issue affects numeric fields where we have CUSTOM formatting to reverse the signage, and it happens in any reports which have this special custom formatting.

Fields  are being exported as "General" format (i.e. text fields) whereas the same fields are exported as format Custom in Fusion R3.

It affects cells which had a fix supplied for in R3 because of problems with reverse signage in R3.

The difference between the affected fields (Revenue) and other fields (for example, Expenses), is that in HFR Studio, there is a formula that reverses the sign (negative becomes positive) for the display of the Revenue balances. In release 3, this is respected (the underlying fields are negative and displayed as positive) whereas in release 8, the fields are converted into General.

Business Impact
--------------------------
Financial reports get a wrong format where users cannot perform numeric functions in release 8 that they could in release 3.

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