R12 AP/IBY Send Separate Remittance Advices Completes With Error "No corresponding LOB data found"
(Doc ID 2420680.1)
Last updated on FEBRUARY 01, 2023
Applies to:
Oracle Payables - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
A custom Separate Remittance Advice "SRA" template is used, "Send Separate Remittance Advice" program is ending in error.
ERROR in "Send Separate Remittance Advice" Log File
Passing formatting Locale to XDO API: us_ZA
length of extract clob doc::31519iby.engine.ExtractFormatter.applyFormat
Enter applyFormat Timestamp: Thu Jun DD 00:00:00 SAST YYYY
size of extract reader ::44iby.engine.ExtractFormatter.applyFormat
size of extract reader before calling Template Helper ::44iby.engine.ExtractFormatter.applyFormat
Before TemplateHelper.processTemplate Call: Thu Jun D 00:00:00 SAST YYYY
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:1175)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3497)
at oracle.apps.iby.engine.ExtractFormatter.applyFormat(ExtractFormatter.java:119)
at oracle.apps.iby.engine.ExtractFormatter.applyFormat(ExtractFormatter.java:281)
at oracle.apps.iby.scheduler.SRAAndPayerNotif.extractAndFormat(SRAAndPayerNotif.java:1029)
at oracle.apps.iby.scheduler.SRAAndPayerNotif.runSRA(SRAAndPayerNotif.java:417)
at oracle.apps.iby.scheduler.SRAAndPayerNotif.runProgram(SRAAndPayerNotif.java:208)
at oracle.apps.iby.scheduler.FDSeparateRemittanceAdvice.runProgram(FDSeparateRemittanceAdvice.java:60)
at oracle.apps.fnd.cp.request.Run.main(Run.java:156)
Error: an error occurred during formatting. Please verify the template is valid.
oracle.apps.iby.exception.PSException: Internal Error to Payment Server: 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 ))
Changes
Create new template for Separate Remittance Advice and assign it in the Payment Process Profile - Reporting TAB.
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 |
Standard Patching Process |
Patch Wizard |
Have more questions? |
References |