You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

how to convert number in words in erp

edited Feb 20, 2024 9:12AM in Reporting and Analytics for ERP 3 comments

In BIP report in cloud , we have to print one amount column in words. We have used the condition as below to convert it , but unfortunately it works upto one limit and later started giving below error. Could anyone please help if we have any option available to convert numbers in words?

There is a limitation while using Julian dates ,It ranges from 1 to 5373484. That’s why if you enter the values more than 5373484, it will throw you an error as shown below:

ORA-01854: julian date must be between 1 and 5373484


to_char(to_date(TRUNC( (  SELECT 

  UPPER (SUBSTR (NVL (ABS (SUM (trunc(rctl.extended_amount))), 0), 1, 1))

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!