Skip to Main Content

Oracle Analytics Cloud

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error in the function check_to_number output

Hello,

I have an RTF template where I use the "check_to_number" function to write the amount in letters. However, I'm facing an issue where the function writes "xx/100" instead of "00/100" when the decimal part of the amount is zero. I have already tried replacing the "decimalStyle" parameter with "DECIMAL_STYLE_FRACTION1" and "DECIMAL_STYLE_FRACTION2". Does anyone know how I can fix this?

Find below the Code and sample screenshots for your reference.

Sample.png

Code.PNG

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked by Renae Stout-Oracle on Jul 8 2024
Added on Mar 23 2023
1 comment
167 views