Excel Function Average and Sum not Working Correctly for FSG Published in Report Manager (Doc ID 1610591.1)

Last updated on FEBRUARY 26, 2016

Applies to:

Oracle Report Manager - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle General Ledger - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Excel 2010
Financial Statement Generator (FSG)

Symptoms

12.1.3
Publishing FSG with content set using the seeded template Generic FSG Drill Template via Report Manager.
Once published highlight any column with data in the Excel sheet and at the bottom of the Excel sheet the labels Average, Count and Sum (Excel functions) and the respective totals are shown.
The totals change as the cursor is moved from row to row, however at random rows the Average and Sum labels and totals disappear and only the Count figure is seen.

Example:
Highlight from row number 21,  some rows down it misses Sum and Average amounts.  Starting from row 19, it displays Sum and Average amounts again.
Issue occurs for all FSG reports.
Excel 2010 is used
Tested with and without row order and issue occurs.

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