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

Last updated on OCTOBER 10, 2022

Applies to:

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

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