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 JUNE 13, 2017

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

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