R12 NLS Numeric Character Issue - Dunning Letters Do Not Display Number Format Correctly Due to ',' As Decimal Separator in xmldata
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.
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
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
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