Home » Applications » Oracle Fusion Apps & E-Business Suite » FND_STANDARD_DATE value set. (FND_STANDARD_DATE giving me error.)
FND_STANDARD_DATE value set. [message #274758] Wed, 17 October 2007 01:29 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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 .
Previous Topic: Automatically populating GL period rates screen (base table GL_TRANSLATION_RATES)
Next Topic: invoices onhold report
Goto Forum:
  


Current Time: Tue Dec 06 00:04:02 CST 2016

Total time taken to generate the page: 0.10004 seconds