OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Date formats..

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

Date formats.. [message #582245]

Tue, 16 April 2013 06:26

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hello Every body..

REP-0613: Value does not match mask 'DD-MON-YYYY'.
ORA-01861: literal does not match format string

REP-0091: Invalid value for parameter 'P_CREATION_DATE_FROM'.

please help me..

Thanks,

Attachment: XXS_RHCITORDQTY_160413.txt
(Size: 2.54KB, Downloaded 2722 times)

[Updated on: Tue, 16 April 2013 06:27]

Report message to a moderator

Re: Date formats.. [message #582246 is a reply to message #582245]

Tue, 16 April 2013 06:29

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Sounds quite obvious: report expects date in format DD-MON-YYYY, but you provided something different.

Report message to a moderator

Re: Date formats.. [message #582248 is a reply to message #582246]

Tue, 16 April 2013 06:44

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Ok,

Here i gave a Date Format like this 'DD-MON-YYYY' , But still i am getting error..

Thanks,

Attachment: image001.jpg
(Size: 32.78KB, Downloaded 1991 times)

Report message to a moderator

Re: Date formats.. [message #582249 is a reply to message #582248]

Tue, 16 April 2013 06:52

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Image says that you set input format mask to DD-MON-YYYY.

Report complains that value passed to that parameter differs from DD-MON-YYYY. For example, instead of 16-APR-2013 you passed 16.04.2013.

Report message to a moderator

Re: Date formats.. [message #582250 is a reply to message #582249]

Tue, 16 April 2013 07:01

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Ok,

which one i have to select for Date format..

Thanks,

Report message to a moderator

Re: Date formats.. [message #582251 is a reply to message #582250]

Tue, 16 April 2013 07:04

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Any valid format you want.

There's nothing wrong with DD-MON-YYYY, but you have to pass date in that format to your report. It expects DD-MON-YYYY, so provide date in that format.

Report message to a moderator

Re: Date formats.. [message #582255 is a reply to message #582251]

Tue, 16 April 2013 07:39

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Hi sivasurya,

If you can brief about the report it would be helpful to help you.
By the replies above what I understood that you are running a concurrent program, which is having an executable as Oracle Reports.
It is custom report or seeded one supplied by Oracle Applications?

From concurrent program the dates will be passed in the format "YYYY/MM/DD HH24:MI:SS", as you see in the text file you have uploaded (2013/04/16 00:00:00).
If your report is custom, then change the mask in the rdf to above format.
If it is seeded report, search in MOS to get a patch or log a new SR.

By
Vamsi

Report message to a moderator

Previous Topic:	Error: APO-PO-14082 Unable to find a charge account
Next Topic:	error REP-0151

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 00:59:03 CST 2024