OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » how to convert number to word in R12

Home » Applications » Oracle Fusion Apps & E-Business Suite » how to convert number to word in R12

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to convert number to word in R12 [message #509093]

Thu, 26 May 2011 01:20

mfahimaamirgmailcom
Messages: 64
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

Report message to a moderator

Re: how to convert number to word in R12 [message #509173 is a reply to message #509093]

Thu, 26 May 2011 06:37

Frank Naude
Messages: 4581
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

Report message to a moderator

Re: how to convert number to word in R12 [message #509255 is a reply to message #509173]

Thu, 26 May 2011 11:54

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	Requisition Import
Next Topic:	Answer these Financial Interview Questions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 16:12:57 CST 2024