My Oracle Support Banner

Report Manager: 'Display Zero' Option in FSG Does not Work in Excel, HTML and PDF Outputs (Doc ID 1950996.1)

Last updated on MARCH 10, 2022

Applies to:

Oracle General Ledger - Version 12.1 and later
Information in this document applies to any platform.
Financial Statement Generator (FSG)

Symptoms

FSG Report that use a Column Set with 'Display Zero' unset errors.
When running the report in General Ledger (Reports -> Request -> Financials), the output is generated without '0' in the Column set (correct).
When run in Report Manager the EXCEL, HTML and PDF output is generated with '0' in the Column set.


STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Publish FSG with custom or seeded template
2. Make sure Display Zero
2. Check the output

NOTE: Depending on the report's definition (example: using/not row order, content set, underline features), the following symptoms may also occur:

ERRORS OR WARNINGS IN LOGFILES

Signal11

OR

Failed to get the expanded values: oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = org.xml.sax.SAXParseException; systemId: file:..../logs/appl/conc/out/o34532942.out; lineNumber: 1129; columnNumber: 15; file:...logs/appl/conc/out/o34532942.out<Line 1129, Column 15>: XML-20121: (Fatal Error) End tag does not match start tag 'fsg:RptLine'.;

Changes

 None

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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