Changing the Date Format on Template Causes Sending Process Failed: XML Data Generation Failed Error (Doc ID 1907190.1)

Last updated on MAY 21, 2024

Applies to:

Goal

Users would like to change the date format on the correspondence items sent from Advanced Collections.  When trying to change the date format on a dunning template, or promise to pay confirmation letter, the correspondence errors with the following:

Sending Process Failed: XML Data Generation Failed

In the query, only the following was changed:
The original query is:
select to_char(sysdate, 'MM/DD/YYYY') currsysdate,

Changed to:
select to_char(sysdate, 'DD-MMM-YYYY') currsysdate,
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.