Home » Applications » Oracle Fusion Apps & E-Business Suite » how to convert number to word in R12
how to convert number to word in R12 [message #509093] Thu, 26 May 2011 01:20 Go to next message
mfahimaamirgmailcom
Messages: 50
Registered: May 2011
Location: pakistan
Member

hi

sir

i use this
select to_char( to_date( 85485758, 'j' ), 'Jsp' ) from dual;
statment for convert number to word but
this statment give me this error

ORA-01854: julian date must be between 1 and 5373484
01854. 00000 - "julian date must be between 1 and 5373484"
*Cause: An invalid Julian date was entered.
*Action: Enter a valid Julian date between 1 and 5373484.

please give me idea how i convert number to word


thank

fahim
Re: how to convert number to word in R12 [message #509173 is a reply to message #509093] Thu, 26 May 2011 06:37 Go to previous messageGo to next message
Frank Naude
Messages: 4569
Registered: April 1998
Senior Member
Your date is too far into the future for Oracle to handle. The maximum Julian date is 5373484 or 31-DEC-99:

SQL> SELECT TO_DATE(5373484, 'j') FROM dual;

TO_DATE(5
---------
31-DEC-99
Re: how to convert number to word in R12 [message #509255 is a reply to message #509173] Thu, 26 May 2011 11:54 Go to previous message
Littlefoot
Messages: 21684
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There were some discussions about the issue; check the results and/or perform your own search.
Previous Topic: Requisition Import
Next Topic: Answer these Financial Interview Questions
Goto Forum:
  


Current Time: Fri Jul 30 12:14:05 CDT 2021