Number Format issues with negative amounts used in FSG reports published to excel and pdf. (Doc ID 1616255.1)

Last updated on JANUARY 03, 2023

Applies to:

Symptoms

On version : 12.1.3 

Generated output for a Financial Statement Generator report has inconsistent thousand and decimal separator for negative amounts.

Example of the exact problem :

Setting are the follow:
Regional settings: 10.000,00
ICX: Numeric characters:10.000,00
ICX: Territory:THE NETHERLANDS

The negative numbers like -1.000,00 are in red but the number format shown is like: -1000,000. 

This is an example how it should work : 

1) Set system profiles as below at user level,
  Currency:Negative Format    :  -XXX
  ICX: Numeric characters       :  10.000,00
2) Relogin into application
3) From Report Manager SuperUser->Financial Report Submission, submit Financial Statement Generator report with following parameters, Report Name: Summary Income Statement
   Period: Dec-03
   Default Template: Generic FSG Template
4) From Control Panel->Regional Settings, change locale to Dutch (Belgium)
5) View above published report from Report Manager SuperUser->Repository Management in Excel, PDF, HTML formats.

Negative amounts in report should be displayed in -XX.XXX format & red color

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.