Collections Correspondence Fails - XML Generation Failed

(Doc ID 1177267.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.

Symptoms

After creating a custom select for a custom correspondence template, you get the following errors in the IEX: Send Dunnings for delinquent customers or when you click Send for Promise to Pay email correspondence:

Error:Sending process failed: no data found.
Error:Sending process failed: XML data generation failed.

For example you may have a custom select for your template that looks something like this:
select org.party_name
from apps.hz_locations loc,
apps.hz_parties org,
apps.hz_parties per,
apps.jtf_rs_resource_extns rs,
apps.hz_customer_profiles hcp,
cuar.cuar_remittance_addresses_t ra
where loc.location_id = 999999
and org.party_id = 999999
and per.party_id = org.party_id
and rs.resource_id = 9999999
and hcp.party_id = org.party_id
and ra.customer_profile_class_id = hcp.profile_class_id
and ra.address_type = 'Dunning' <==

or a select that looks something like this:
select *
from iex_delinquencies_all
where cust_account_id = :Account_Id;

or a select that looks something like this:
(select alias from ar_collectors
where name = 'Default Collector') collector_alias,
(select telephone_number from ar_collectors
where name = 'Default Collector') collector_alias_phone,

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