Oracle BIP – RTF Template- Display Amount In Words

•<?xdofx:expression?>

•<?xdofx:to_check_number(amount, precisionOrCurrency, caseType, decimalStyle)?>

•<?xdofx:to_check_number(INVOICE_AMOUNT , INVOICE_CURRENCY_CODE, ‘CASE_INIT_CAP’, ‘DECIMAL_STYLE_WORDS’)?>

AttributeDescriptionValid Value
amountThe number to be transformed.Any number or Column name
precisionOrCurrencyFor this attribute you can specify either the precision, which is the number of digits after the decimal point; or the currency code, which will govern the number of digits after the decimal point. The currency code does not generate a currency symbol in the output.An integer, such as 2; or a currency code, such as ‘USD’.
caseTypeThe case type of the output.Valid values are:
‘CASE_UPPER’,
‘CASE_LOWER’,
‘CASE_INIT_CAP’
decimalStyleOutput type of the decimal fraction area.Valid values are:
‘DECIMAL_STYLE_FRACTION1’, ‘DECIMAL_STYLE_FRACTION2’,
‘DECIMAL_STYLE_WORD’

Leave a Reply

Your email address will not be published.