How to convert number to text for non-English language

Question

We have a requirement to show the Total Amount of Purchase Order into words in rtf. We were able to display it in English, but the requirement is to display in a non-English language (in this case it's Vietnamese).

How do we achieve that?

Riyaz Ali-Oracle · Answer

Hi Ulfi,

Please review the below KB note:

How to translate the Numbers to Words in BI Publisher report in Vietnam language? KB74271

Thanks,

Riyaz Ali

Rajasekhar Bandaru-Oracle · Answer

Hi Ulfi

Please review the given help center links

https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/format-numbers-dates-and-currencies.html#GUID-AE81FD1D-7417-4739-9643-18BB9D964F3D

https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/work-translation-files.html#GUID-CE2DC59D-1F3E-406A-B03D-F9912C8B63A6

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/27820/how-to-convert-number-to-text-for-non-english-language

You can use a tag like below in your RTF:

<?xdoxslt:toCheckNumber(‘ar-SA’, TOTAL, ‘AED’,’CASE_UPPER’)?>

Thanks.