AGIS Oracle Intercompany Account Details Report - Completing Warning: One or more post-processing actions failed. Consult the OPP service log for details. (Doc ID 1989925.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

AGIS Oracle Intercompany Account Details Report is completing with below warning, seen in the log:

Output file size:
755256

ERROR
-----------------------

+------------- 1) PUBLISH -------------+
Beginning post-processing of request 8677391 on node XXXXXXXXXXX at 10-FEB-2015 01:34:14.
Post-processing of request 8677391 failed at 10-FEB-2015 01:34:15 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
+--------------------------------------+

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Intercompany Super User -> Requests -> Schedule-> Oracle Intercompany Account Details Report
Select parameters and Submit.

This report has not been generated in the past with success.
All other XML reports generate without error.
XML tagged data is generated, but is not being published into a final report output.

OPP log is showing the following errors:

Starting XML Publisher post-processing action.
Template code: null
Template app:  null
Language:      null
Territory:     null
Output type:   null
 Output file was found but is zero sized - Deleted
 [UNEXPECTED] [434965:RT9345820] 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.APPLICATION_SHORT_NAME= :1 AND L.LOB_CODE = :2 AND L.APPLICATION_SHORT_NAME = B.APPLICATION_SHORT_NAME AND L.LOB_CODE = B.TEMPLATE_CODE AND (L.LOB_TYPE = 'TEMPLATE' OR L.LOB_TYPE = 'MLS_TEMPLATE') AND  ( (L.LANGUAGE = :3 AND L.TERRITORY = :4) OR  (L.LANGUAGE= B.DEFAULT_LANGUAGE AND L.TERRITORY= B.DEFAULT_TERRITORY ))
    at oracle.apps.xdo.oa.schema.server.TemplateInputStream.initStream(TemplateInputStream.java:403)
    at oracle.apps.xdo.oa.schema.server.TemplateInputStream.<init>(TemplateInputStream.java:236)
    at oracle.apps.xdo.oa.schema.server.TemplateHelper.getTemplateFile(TemplateHelper.java:1164)
    at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3451)
    at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)
    at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:302)
    at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176)

The report and template being used are the latest versions available: FUNVRPTB.pls, FUNARPT.rtf.
Neither report or template have been modified from the seeded files.

Finding that during the Report Submission, the step to choose the layout (template) is being skipped
(step 4 is missing (layout selection) and that in step 7, no layout is shown to be selected (template name is blank)).



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms