CODEWITHSUNDEEP
oracle-databaseoracle12crtfbi-publisher
Lawrencxe
Lawrencxe

Reputation: 81

Convert the total amount in words

I'm converting my total amount into words using bi publisher. Btw, the amount is base on the data from the data set. Can someone help me what to do? Thanks

<?xdofx:to_check_number,sum(COLUMN_NAME, ‘EUR’, ‘CASE_UPPER’, ‘DECIMAL_STYLE_WORDS’)?>

I expect the output to be in words but the actual ouput is blank.

Upvotes: 0

Views: 4416

Answers (5)

Irine
Irine

Reputation: 11

So basically the function is looking for integer value to convert to char. Instead of giving the exact column name -> 'AMOUNT'. Make the template understand it is an number stored in a placeholder.

Upvotes: 0

Assaduzzaman Sarker
Assaduzzaman Sarker

Reputation: 1

You can try this one which is working for my case.

<?xdoxslt:toWordsAmt(2300)?> 

CASE_INIT_CAP

Upvotes: 0

Ranjith R
Ranjith R

Reputation: 1589

Use the function xdoxslt:toCheckNumber

Like this:

<?xdoxslt:toCheckNumber($_XDOLOCALE, sum(COLUMN_NAME), ‘EUR’, ‘CASE_UPPER’, ‘DECIMAL_STYLE_WORDS’)?>

For a detailed explanation, check this page. But bear in mind, this is an undocumented function.

Upvotes: 1

EdHayes3
EdHayes3

Reputation: 1953

In E-Business Suite r12, the XML file from the "out of the box" payments module has amount in text: OutboundPaymentInstruction/OutboundPayment/PaymentAmountText

Upvotes: 1

Barbaros &#214;zhan
Barbaros &#214;zhan

Reputation: 65363

<?xdofx:to_check_number(sum(COLUMN_NAME), 'EUR', 'CASE_UPPER', 'DECIMAL_STYLE_WORDS')?>

should work with fixed quotes and converted part ,sum(COLUMN_NAME,... into(sum(COLUMN_NAME),....

Upvotes: 0

Related Questions