Program - Publish FSG Report Shows Output as XML Code and Errors: ORA-00907: missing right parenthesis, XML-20121 End tag does not match start tag (Doc ID 2804030.1)

Last updated on MARCH 07, 2023

Applies to:

Symptoms

Publishing some Financials Statement Generator (FSG) reports in General Ledger through  Program - Publish FSG Report ends with error and the output appears as XML code. The Publisher's log (OPP log) also shows error.

The latest FSG patches were applied but did not resolve the issue - according to Note 189282.1 - FSG: Apply Latest Patch - How to Find it and Verify it has been Applied

WHAT WORKS:

Running the same reports in TEXT output works fine and the output is correct.

Other reports in the same instance work fine and the output is correct as XML.

ERRORS:

in  Program - Publish FSG Report logfile:

rgrdpg.rgxbrl_colhead_trim - Prepare
ORA-00907: missing right parenthesis

One or more post-processing actions failed. Consult the OPP service log for details

in OPP log:
Template code: RG_FSGXML_BASIC_W_DRILL
Template app: SQLGL
Language: en
Territory: US
Output type: RTF
[7/8/21 10:49:14 PM] [159862:RT20107698] Output file was found but is zero sized - Deleted
[7/8/21 10:49:14 PM] [UNEXPECTED] [159862:RT20107698] java.lang.reflect.InvocationTargetException
Caused by: org.xml.sax.SAXParseException; lineNumber: 1564; columnNumber: 15; : XML-20121: (Fatal Error) End tag does not match start tag 'fsg:RptLine'.
  at oracle.xdo.parser.v2.XMLError.flushErrorHandler(XMLError.java:441)

in the XML output:

<fsg:ColDispFormat>
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
--------------------------------------------------------------------------------
End tag 'MasterReport' does not match the start tag 'fsg:RptLine'. Error processing resource < ... >
</MasterReport>
--^
s="tx">999999999.99</fsg:ColDispFormat>


STEPS TO REPRODUCE:
1. General Ledger Responsibility > View > Requests > Submit a new request
2. Run RGFSGXML: Program - Publish FSG Report for a specific report
3. Observe the output is actually XML code instead of financials data
4. The logfile shows error, also the Publisher's log errors
5. GL Responsibility > Reports > Request > Financials > Submit the same FSG report with Text output
6. Note this completes fine and the financial data is available

Changes

New reports defined in the system. No other changes related to patching, upgrades.

Cause

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