Receipts Workbench: Pre-Direct Debit Notification Letter Going into Warning and Not Showing Any Output (Doc ID 1604280.1)

Last updated on JANUARY 03, 2014

Applies to:

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

Symptoms

Pre-Direct Debit Notification Letter going into Warning and not showing any output.

Log file gives following error message :

Beginning post-processing of request 525272 on node ERPDEMO at 26-NOV-2013 15:02:55.
Post-processing of request 525272 failed at 26-NOV-2013 15:02:55 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.

OPP log details:

[11/26/13 11:20:17 AM] [29765:RT524584] Executing post-processing actions for request 524584.
[11/26/13 11:20:17 AM] [29765:RT524584] Starting XML Publisher post-processing action.
[11/26/13 11:20:17 AM] [29765:RT524584]
Template code: ARSEPADNT
Template app:  AR
Language:      en
Territory:     US
Output type:   RTF
[11/26/13 11:20:17 AM] [29765:RT524584] Output file was found but is zero sized - Deleted
[11/26/13 11:20:17 AM] [UNEXPECTED] [29765:RT524584] 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 = :5 AND L.TERRITORY = :6) 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)

[11/26/13 11:20:17 AM] [29765:RT524584] Completed post-processing actions for request 524584.


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