My Oracle Support Banner

R12 NLS Numeric Character Issue - Dunning Letters Do Not Display Number Format Correctly Due to ',' As Decimal Separator in xmldata (Doc ID 1671693.1)

Last updated on FEBRUARY 11, 2019

Applies to:

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

Symptoms

In 12.1.3 in Collections

Dunning Letters do not display the number format correctly.

ICX: Numeric Character profile option to "10 000,00"
==> this is pulled while running program Generate Dunning Letters and causes the xmldata to be stored with ',' comma in the table.

The delivery templates are showing strange number formats mixed with '.' and ','

Expectation is that the iex_xml_request_histories.xmldata is stored with '.' to have the number format done in the rtf based on the customer language setting.


If you have the following setting it works:
       ICX: Numeric Character profile option to "10 000.00" ==> with a dot as decimal separator -- xml data is stored with '.' and English and Norwegian results are fine

       English 5,555.66
       Norwegian 5.555,66

Note:

You might also experience the error below during Delivery of the Dunning Letters:

IEXXmlDelivery [Mar-27-2014 15:15:26]: cannot process xdo template
IEXXmlDelivery [Mar-27-2014 15:15:26]: updateStatus: sTempStatus=XML TEMPL PRCS FAILED DUN_COPY
IEXXmlDelivery [Mar-27-2014 15:15:26]:Failure Reason: Failed to submit delivery request. Check the corresponding profile values and config file
IEXXmlDelivery [Mar-27-2014 15:15:26]: updateStatus: invoiceCopyExists =false
IEXXmlDelivery [Mar-27-2014 15:15:26]: updateStatus: updating staus column TempStatus=XML TEMPL PRCS FAILED DUN_COPY

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
 Still Have Questions?
References


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