Reporting and Analytics for ERP

Get Involved. Join the Conversation.


    Sanin Thulapparumban
    Print Amount in Arabic in OTBI Report
    Topic posted April 16, 2019 by Sanin ThulapparumbanBlue Ribbon: 750+ Points, tagged BI Publisher, OBIEE Answers, OTBI 
    82 Views, 3 Comments
    Print Amount in Arabic in OTBI Report
    Print Amount in Arabic in OTBI Report


    We have developed a report where every month we sent a balance confirmation letter to customer. This balance could be negative and positive value. Complete letter is in Arabic mostly with static Arabic statement. Only thing we have to print in this report is Customer Balance Amount for that month in numbers and Arabic language. We are able to print the Balance Amount in numbers (like SAR 14,000,000) but we are not able to print this in Arabic i.e Arabic translation of FOURTEEN MILLION RIYALS.

    Please let us know if there is a way to achieve this.






    • Sanin Thulapparumban

      Correction: This Report is BIP Report with Data Model and Report Template.

    • Manish Pesswani
      xdofx:to_check_number(12345.67, 'EUR', 'CASE_LOWER', 'DECIMAL_STYLE_WORDS') 

      try this in your RTF file . Update the parameters passed as per your need.

    • Sanin Thulapparumban

      Thanks Manish for the reply. We tried this. To make this tag work we need to change the preference language to Arabic. 

      Requirement is this should work independent of preference language change.