Changing the Date Format on Template Causes Sending Process Failed: XML Data Generation Failed Error

(Doc ID 1907190.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle Advanced Collections - Version 12.1.3 and later
Information in this document applies to any platform.

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

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