FSG report print error, log file shows java.sql.SQLException:No corresponding LOB data found

Error message:

+---------------------------------------------------------------------------+
Log information for the PLSQL program starts
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Plsql end of log information for the program
+---------------------------------------------------------------------------+




+---------------------------------------------------------------------------+
Executing Request completion Options ...


Output File Size:
84652




The output file is not printed because:
Printing options for this report have been disabled.


+-------------1) PUBLISH-------------+
Request on Node Handdev 8635834 for post-processing since 15-08-2014 10:02:03.
The post-processing of request 8635834 failed with the 15-08-2014 10:02:03 and an error message appears:
One or more post-processing actions failed. Consult the OPP service log for details.
+--------------------------------------+


+-------------2) PRINT-------------+
+--------------------------------------+




The Execute Request completion option has been completed.


+---------------------------------------------------------------------------+
A concurrent request has been completed
The current system time is 15-08-2014 10:02:03


+---------------------------------------------------------------------------+

To view log information:

Metalink on the search, found to be a bug, but only said to be version

Oracle General Ledger-version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
BI Publisher (formerly XML Publisher)-Version 11.5 to 11.5 [Release 11.5

Check it out.

Attached Metalink

FSG: ' Program-publish FSG report ': One Step Publish to XML Document after XML Publisher 5.6 Upgrade fails with No corres ponding LOB Data Found (document ID 398905.1)

Go to bottom

In this Document Symptoms Changes Cause Solution Still have Questions? References Applies to:oracle general ledger-version 11.5.10.2 to 11.5.10.2 [Release 11.5.10] BI Publisher (formerly XML Publisher)-Version 11.5 to 11.5 [Release 11.5] Information in this document applies to any platform. Program-publish FSG report (Xml/bi Publisher) Program:rgrarg-financial Statement Generator (FSG) Symptoms You upgraded the XML Publisher to 5.6. You attempt to publish a FSG report in one step. It fails with Error the error: Java.sql.SQLException:No corresponding LOB data found:select l.file_data file_data, Dbms_lob. GetLength (L.file_data) file_length, L.language LANGUAGE, L.territory TERRITORY, B.default_language default_language, B . Default_territory Default_territory,b.template_type_code Template_type_code, b.use_alias_table USE_ALIAS_TABLE, B. Start_date start_date, B.end_date end_date, B.template_status template_status, b.use_alias_table USE_ALIAS_TABLE, B.DS _app_short_name Ds_app_short_name, B.data_source_code Data_source_code, L.lob_type LOB_TYPE from XDO_LOBS L, XDO_ Templates_b B WHERE (l.lob_type = ' TEMPLATE ' OR l.lob_type = ' mls_template ') and l.application_short_name=: 1 and L.lob_co DE =: 2 and l.application_short_name = B.application_short_name and L.lob_code = B.template_code and ((L.language =: 3 an D l.territory =: 4) or (L.language =: 5 and L.territory =: 6) or (l.language= b.default_language and l.territory= B.defau Lt_territory)) At Oracle.apps.xdo.oa.schema.server.TemplateInputStream.initStream (templateinputstream.java:357) At Oracle.apps.xdo.oa.schema.server.templateinputstream.<init> (templateinputstream.java:193) At Oracle.apps.xdo.oa.schema.server.TemplateHelper.getTemplateFile (templatehelper.java:1223) At Oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate (templatehelper.java:3547) At Oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate (templatehelper.java:3614) At Oracle.apps.xdo.oa.cp.JCP4XMLPublisher.runProgram (jcp4xmlpublisher.java:814) At Oracle.apps.fnd.cp.request.Run.main (run.java:148) Steps to reproduce: 1. General Ledger Responsibility 2. Other:Request:Submit a new Request:single Request 3. "Program-publish FSG Report" and enter the parameters Changes Upgraded XML Publisher to 5. Cause The cause of this problem have been identified in unpublished bugs 5097575 FSG PUBLISHER DOES not work in 5.6.1 XML PUBLISHER 5.6. It is caused by XML Publisher, which requires different parameters. Solution To Implement the solution take the following steps: ------------------ Apply Patch 5585863 FSG functionality for r11i including XML as of 10/17/06. Note:this Patch delivers logic to enable your to submit the Program-publish FSG report with XDO versions 5.0, 5.5, 5.6. 0 and 5.6.1. 1. Download and install patch:5585863. 2. Read the Readme.txt and ensure all prerequisites is met. 3. Install on a TEST instance experiencing the same issue and after have done appropriate backups. 4. Bounce the server 5. Test the issue 6. If the issue is resolved, migrate to other instances as appropriate. Still have Questions? To discuss the information further with Oracle experts and industry peers, we encourage you to review, join or start a di Scussion in the My Oracle support General Ledger Community. To provide feedback in this note, click on theRate this documentLink. REFERENCESBUG:5097575-FSG publisher DOES not on 5.6.1 but work in XML Publisher 5.6 BUG:5097575-FSG publisher DOES not on 5.6.1 but work in XML Publisher 5.6 Bug:5585863-program-publish FSG Report DOES no work for XDO 5.6 Note:337999.1-about XML Publisher Release 5.6 Note:362431.1-publish FSG report fails after XML Publisher 5.6.1 Upgrade