Home » Developer & Programmer » Reports & Discoverer » Conversion of Currency in to words (Reports 6i)
Conversion of Currency in to words [message #283466] Tue, 27 November 2007 04:43 Go to next message
Messages: 17
Registered: October 2007
Junior Member

I am developing an invoice report based on the tables ra_customer_trx_all and ra_customer_trx_lines_all. I want to display the total invoice amount in words based on the currency code in a formula column

The currency_code column in ra_customer_trx_lines_all is having data as USD,GBP,INR etc.

suppose the invoice amount is 10000 and the currency_code is USD.
Then the amount should be displayed as US DOLLARS TEN THOUSAND ONLY

If the Currency code is INR then the amount should be displayed as RUPEES TEN THOUSAND ONLY

Please suggest me a solution

Thanks & Regards
Re: Conversion of Currency in to words [message #283473 is a reply to message #283466] Tue, 27 November 2007 05:07 Go to previous message
Messages: 20847
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is the way to do it:
SQL> select to_char(to_date(1234, 'j'), 'jsp') num_to_words from dual;

one thousand two hundred thirty-four


You'll have to concatenate 'USD', 'RUPEES' etc. by yourself, depending on currency name.
Previous Topic: REP-1401 fatal PL/SQL error
Next Topic: want to increase the viewport size of report paramtere form
Goto Forum:

Current Time: Wed Oct 26 01:10:27 CDT 2016

Total time taken to generate the page: 0.14707 seconds