My Oracle Support Banner

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 SEPTEMBER 06, 2021

Applies to:

Oracle General Ledger - Version 12.2 and later
Information in this document applies to any platform.
RGFSGXML: Program - Publish FSG Report
FSG - Financials Statement Generator

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

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.