Each digit of Amount in words in RTF Report — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Each digit of Amount in words in RTF Report

Received Response
143
Views
8
Comments

Summary

Each digit of Amount in words in RTF Report

Content

Hi Everyone,

 

I am working on check print report in fusion and I have requirement from business as to convert each digit of amount in words.

For Example : 6978.09, it should be print like "SIX NINE SEVEN EIGHT PERIOD ZERO NINE".

Anyone have idea regarding this as how to convert each digit in word.

 

Thanks in Advance.

 

Regards,

Ankit

Answers

  • Ankit Kumar-91304
    Ankit Kumar-91304 Rank 1 - Community Starter

    Thanks Brajesh !!

    But its not printing each digit in words, Its printing whole amount in word.

    I have to print "One Two Five Two Period Eight Nine" for 1252.89 amount.

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    You can use <?xdoxslt: toWordsAmt(1252.89)?> but not sure amount format fulfill your requirement

  • Dir_Pal
    Dir_Pal Rank 6 - Analytics Lead

    select to_char(to_date(floor(6978.09),'J'),'Jsp')||' and '||

    to_char(to_date((6978.09-(floor(6978.09)))*100,'J'),'Jsp') from dual

  • Pieter Breugelmans-Oracle
    Pieter Breugelmans-Oracle Rank 3 - Community Apprentice

    Your requirement of printing out each digit of the check amount individually is highly unusual in the context of a "check print report". A standard practice for checks is for the amount to be spelled out in words. Are you absolutely sure that the requirement is clearly understood as I've never came across such myself before?

  • Arti Sangar
    Arti Sangar Rank 1 - Community Starter

    Thanks !!

    But its not printing each digit in words, Its printing whole amount in word.

  • Sketz
    Sketz Rank 4 - Community Specialist

    I would assume that you should do that in the data model and not inside of a template.

    A relatively simply PLSQL-Loop where you extract one digit after another and "translate" it should be enough

  • Arti Sangar
    Arti Sangar Rank 1 - Community Starter

    Hi Pieter

    I am sure about requirement that I have to print each digit in word.

    Thanks

    Ankit Kumar

  • ZZHAO2022
    ZZHAO2022 Rank 1 - Community Starter

    Hi Ankit,

     

    Did you get this problem solved? I am encountering the same issue. For example, I need to print 123 as One Two Three where one is under the Hundred digit, two is under the tens digit and three is under the unit digit. Is it doable in RTF template?