Fusion BIP: Non Numeric columns throw "The number in this cell is formatted as text or preceded by an apostrophe" error when report is exported as Excel

(Doc ID 2152293.1)

Last updated on NOVEMBER 04, 2016

Applies to:

Oracle Fusion Financials Common Module - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

The issue can be reproduced at will with the following steps:


1] Create a Report online using the Report Editor, the Report should contain a Currency column
2] Save the Report
3] Run it Online
4] Select Export > Excel 2007+
5] Open the downloaded Excel, the currency column is of General Format and a notification near each cell says, "The number in this cell is formatted as text or preceded by an apostrophe."

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