Oracle Apps Has Provided an Inbuilt function AP_AMOUNT_UTILITIES_PKG which can be used to achieve the result.
SELECT (ap_amount_utilities_pkg.ap_convert_number (111234234324)) Amount_In_Word
FROM DUAL
SELECT (ap_amount_utilities_pkg.ap_convert_number (111234234324)) Amount_In_Word
FROM DUAL
Example:
One hundred eleven billion two hundred thirty-four million two hundred thirty-four thousand three hundred twenty-four
is there a way to convert into other languages as well?
ReplyDeletefor ex: R$ 3.545.601,35 is in Brazil currency.
I have to print as..
três milhões, quinhentos e quarenta e cinco mil, seiscentos e um reais e trinta e cinco centavos