How to dynamic format currency amounts in an RTF template (ref. Doc ID 1588933.1)?
Summary:
Hello,
I have the following challenge that we need to format certain currency fields in an RTF (invoice) template regarding certain conditions WITHIN the template. So we want to be independent from any locale settings of users who run the report etc.
Saying this Oracle was pointing me to the following Doc ID 1588933.1 which seems to be a 2 part solution which I tried but didn't work like expected:
1) Use xsl:decimal-format in the template to force the number format.
Create a form field(with type Regular Text) at the top of Layout template.
Click on Add help text and enter the following text: