NumText() DAL Function Correctly Produces American English Text, But Not True English Text

(Doc ID 2390477.1)

Last updated on APRIL 30, 2018

Applies to:

Oracle Documaker - Version 12.6 and later
Information in this document applies to any platform.

Symptoms

When using the NumText() DAL function to put a number into text format, the text getting generated is missing a few 'and' statements.

For example, using the value: $312,230,451.25.

The requirement is that this is to display as:
"Three hundred and twelve million two hundred and thirty thousand four hundred and fifty one dollars and twenty five cents"

NumText() is displaying as:
"Three hundred twelve million two hundred thirty thousand four hundred fifty one dollars and twenty five cents

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms