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:
Oracle Advanced Collections - Version 12.1 to 12.1 [Release 12.1]Information in this document applies to any platform.
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
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 |