| FND_STANDARD_DATE value set. [message #274758] |
Wed, 17 October 2007 01:29  |
alayam
Messages: 8
Registered: November 2006
Location: Hyderabad
|
Junior Member |
|
|
Hi! All
I'm trying to use FND_STANDARD_DATE value set.
My requirement is when we submit the request i need to give the actual shipment date as parameter. That time I should able to enter any date format for example 17-OCT-2007 or 17OCT07 or 17oct07 .. It should convert Standard date format (17-OCT-2007 )when I TAB out. I have used FND_STANDARD_DATE but it is converting the date format into standard as I want. But after submitting the request it is taking TIMESTAMP.. so that it is giving
"Cause: FDPSTP failed due to ORA-01861: literal does not match format string
ORA-06512: at line 1"
Even I have TRUNCATED my parameter in my SQL query. that is
where trunc(actual_shipment_Date) = TRUNC(p_date);
Please any one could help me on this issue. It is very urgent
Thanks in advance.
Chandu.
|
|
|
|
| Re: FND_STANDARD_DATE value set. [message #274809 is a reply to message #274758] |
Wed, 17 October 2007 04:01  |
ggr88
Messages: 31
Registered: October 2007
Location: Wellington, New Zealand
|
Member |
|
|
Hi,
Declare your parameters as Char (reports) or varchar2 (pl/sql), create local variables as dates, then call fnd_date.canonical_to_date to get from parameter to local variable. Something like this:
procedure do_something
( errbuf out varchar2
, retcode out varchar2
, p_date_from in varchar2
, p_date_to in varchar2
)
is
l_date_from date;
l_date_to date;
begin
l_date_from := fnd_date.canonical_to_date(p_date_from);
l_date_to := fnd_date.canonical_to_date(p_date_to);
...
|
|
|
|
| Re: FND_STANDARD_DATE value set. [message #274817 is a reply to message #274809] |
Wed, 17 October 2007 05:10 |
alayam
Messages: 8
Registered: November 2006
Location: Hyderabad
|
Junior Member |
|
|
Hi! ggr88
Thanks a lot for ur reply.
I got solution. but will u tell me ur gmail id i would like to ask u some more questions on this topic. if u could help me i can finish this project today itself.
Thanks and regards,
chandra
My gmail id is alayamc@gmail.com please contact me in this id.
waiting for u .
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
