Canadian Cheque Writer(XML) Errors With No Corresponding LOB Data Found With Custom Template (Doc ID 2147798.1)

Last updated on JUNE 08, 2016

Applies to:

Oracle HRMS (Canada) - Version 12.1 HRMS RUP8 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 HRMS RUP8 version, in Test,

When attempting to run the Canadian Check Writer (XML) process with a custom template,
the following error occurs.

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.TERRITO
RY TERRITORY, B.DEFAULT_LANGUAGE DEFAULT_LANGUAGE, B.DEFAULT_TERRITORY DEFAULT_T
ERRITORY,B.TEMPLATE_TYPE_CODE TEMPLATE_TYPE_CODE, B.USE_ALIAS_TABLE USE_ALIAS_TA
BLE, B.START_DATE START_DATE, B.END_DATE END_DATE, B.TEMPLATE_STATUS TEMPLATE_ST
ATUS, 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_TE
MPLATES_B B WHERE L.APPLICATION_SHORT_NAME= :1 AND L.LOB_CODE = :2 AND L.APPLICA
TION_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.LANGUAG
E= B.DEFAULT_LANGUAGE AND L.TERRITORY= B.DEFAULT_TERRITORY ))
at oracle.apps.xdo.oa.schema.server.TemplateInputStream.initStream(TemplateInpu
tStream.java:403)
at oracle.apps.xdo.oa.schema.server.TemplateInputStream.(TemplateInputStr
eam.java:236)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.getTemplateFile(TemplateHelp
er.java:1164)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelp
er.java:3451)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelp
er.java:3548)
at oracle.apps.pay.core.documents.DocGenerator.process(DocGenerator.java:521)

HR_6882_HRPROC_ASSERT
LOCATION pyjavacom:2
APP-PAY-06882: Assertion failure detected at location pyjavacom:2.

Cause: an internal error has occurred at location pyjavacom:2.

Action: please contact your Oracle customer representative.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Run the Canadian Check Writer (XML) process with a custom template
2. Observe the error


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot continue testing the Canadian Check Writer (XML) process; this will also delay using the process in Production

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