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)
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
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'.;
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