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 MAY 21, 2024

Applies to:

Symptoms

In Collections Workbench

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

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