IEX_BULK_XML_DELIVERY Completes, But Does Not Produce An Output - Log Shows sqlexp:oracle.apps.xdo.XDOException IEXXmlDelivery: cannot process xdo template (Doc ID 1314030.1)

Last updated on AUGUST 18, 2016

Applies to:

Oracle Advanced Collections - Version 12.1.1 and later
Information in this document applies to any platform.
IEX_BULK_XML_DELIVERY module: IEX: Bulk XML Delivery Manager


Symptoms

IEX_BULK_XML_DELIVERY module: IEX: Bulk XML Delivery Manager does not produce an outfile if if certain customers are included.
If it is run just for a small range of customers it's working fine.

The logfile shows at the bottom:

IEXXmlDelivery [Apr-12-2011 10:38:46]: Qurey to fetch Party Name for given Party id : select party_name from hz_parties where party_id=:1
IEXXmlDelivery [Apr-12-2011 10:38:46]: Party Name: ABC
IEXXmlDelivery [Apr-12-2011 10:38:46]: Qurey to fetch Party Number for given Party id : select party_number from hz_parties where party_id=:1
IEXXmlDelivery [Apr-12-2011 10:38:46]: Party Number: 3839
IEXXmlDelivery [Apr-12-2011 10:38:46]: Qurey to fetch Account Number for given Account Id : select account_number from hz_cust_accounts where cust_account_id=:1
IEXXmlDelivery [Apr-12-2011 10:38:46]: Account Number: 2499
IEXXmlDelivery [Apr-12-2011 10:38:46]: Processing Dunning letter using getCharacterStream
IEXXmlDelivery [Apr-12-2011 10:38:46]:before setting flag invoiceCopyExists :false
IEXXmlDelivery [Apr-12-2011 10:38:46]:After setting flag invoiceCopyExists :false
IEXXmlDelivery [Apr-12-2011 10:38:46]: Query to fetch XDO Template Code : SELECT xdo.template_code FROM XDO_TEMPLATES_VL xdo, IEX_QUERY_TEMP_XREF xref WHERE xdo.template_id = xref.template_id and xref.query_temp_id=:1 AND xdo.Application_short_name = 'IEX'
IEXXmlDelivery [Apr-12-2011 10:38:46]: request_id=11267
IEXXmlDelivery [Apr-12-2011 10:38:46]: method=PRINTER
IEXXmlDelivery [Apr-12-2011 10:38:46]: dest=/printers/be_nashua
IEXXmlDelivery [Apr-12-2011 10:38:46]: subject=TEST Message from Collections Department
IEXXmlDelivery [Apr-12-2011 10:38:46]: template_code=IEXDNHRD3
IEXXmlDelivery [Apr-12-2011 10:38:46]: lang=null
IEXXmlDelivery [Apr-12-2011 10:38:46]: terr=null
IEXXmlDelivery [Apr-12-2011 10:38:46]: done to get xmldata
Query to find Logged in User details : SELECT j.user_id FROM jtf_rs_resource_extns j, fnd_user u WHERE j.resource_id = :1 and j.user_id = u.user_id
IEXXmlDelivery [Apr-12-2011 10:38:46]: After User level check Subject: TEST Message from Collections Department
IEXXmlDelivery [Apr-12-2011 10:38:46]: process Template
IEXXmlDelivery [Apr-12-2011 10:38:46]: get Locale
IEXXmlDelivery [Apr-12-2011 10:38:46]: start getDefaultLocale
IEXXmlDelivery [Apr-12-2011 10:38:46]: oraLang=US
IEXXmlDelivery [Apr-12-2011 10:38:46]: Query to fetch language and territory details : select iso_language, iso_territory from fnd_languages where language_code = :1
IEXXmlDelivery [Apr-12-2011 10:38:46]: defaultLang=en
IEXXmlDelivery [Apr-12-2011 10:38:46]: defaultTerr=US
IEXXmlDelivery [Apr-12-2011 10:38:46]: calling TemplateHelper.processTemplate
In getProfileValue getting Value for Profile : IEX_USE_CUST_LANG_DUNN_LETTER
UserId in getProfileValue : 1055
Fetching profile value from User level in getProfileValue for User: 1055
profileValue in getProfileValue : Y
IEXXmlDelivery [Apr-12-2011 10:38:46]: Profile : IEX use language for dunning letter : Y
IEXXmlDelivery [Apr-12-2011 10:38:46]: pCpContext : input to template helper : [oracle.apps.fnd.cp.request.CpContext@1d840cd $Revision: 120.14 $ extends [oracle.apps.fnd.common.Context@1d840cd $Revision: 120.7 $ {sessionId=0x1d840cd,conn=oracle.jdbc.driver.T4CConnection@16477d9,state=oracle.apps.fnd.common.StateStack@13d9460}] {isDedicated=false}]
IEXXmlDelivery [Apr-12-2011 10:38:46]: sTempCode input to template helper : IEXDNHRD3
IEXXmlDelivery [Apr-12-2011 10:38:46]: jLocale[0] : input to template helper : en
IEXXmlDelivery [Apr-12-2011 10:38:46]: jLocale[1] : input to template helper : US
IEXXmlDelivery [Apr-12-2011 10:38:46]: io_result_reader : input to template helper : oracle.jdbc.driver.OracleClobReader@1de0c09
IEXXmlDelivery [Apr-12-2011 10:38:46]: pdfDomain.getLength() : 0
IEXXmlDelivery [Apr-12-2011 10:38:46]: htmlDomain.getLength() : 0
In getProfileValue getting Value for Profile : ICX_CLIENT_IANA_ENCODING
UserId in getProfileValue : null
Fetching profile value from Site level in getProfileValue :
profileValue in getProfileValue : UTF-8
IEXXmlDelivery [Apr-12-2011 10:38:46]: Calling processTemplate procedure with language parameter PDF
IEXXmlDelivery [Apr-12-2011 10:38:46]: sqlexp:oracle.apps.xdo.XDOException
IEXXmlDelivery [Apr-12-2011 10:38:46]: pdfDomain.getLength() : 0
IEXXmlDelivery [Apr-12-2011 10:38:46]: htmlDomain.getLength() : 0
IEXXmlDelivery [Apr-12-2011 10:38:46]: output.size() 0
IEXXmlDelivery [Apr-12-2011 10:38:46]: cannot process xdo template
IEXXmlDelivery [Apr-12-2011 10:38:46]: updateStatus: sTempStatus=XML TEMPLATE PROCESSING FAILED

After this the program stops.

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