Currency Formats

SELECT

TO_CHAR(12334,FND_CURRENCY.GET_FORMAT_MASK('CLF',20)) formatted_amt

FROM DUAL;

-- 12,334.0000

SELECT

TO_CHAR (12334,FND_CURRENCY.GET_FORMAT_MASK('USD',20)) formatted_amt

FROM DUAL;

-- 12,334.00

SELECT

TO_CHAR (12334,FND_CURRENCY.GET_FORMAT_MASK('KWD',20)) formatted_amt

FROM DUAL;

--12,334.000

Also, adding some codes to handle this in Java (but we need to test this out):

String numberFormat = oracle.apps.jtf.util.NumFormat.buildJavaNumberFormat(<Oracle_connection>,defaultcurrency,20 );
BigDecimal num1 = new BigDecimal(<your_number>);
String yourText = (oracle.apps.jtf.util.NumFormat.formatNumber(num1, numFormat));