Not a Valid Month

system · February 13, 2012, 12:58pm

Hi,

I have created a webi report with a date prompt. When i am running the report, it is giving the following error

“ORA-01843: not a valid month (WIS 10901)”

The datatype of the date object is Timestamp (6) in the database and the object is getting parsed in the universe. The format is dd/mm/yyyy and i am entering the prompt values in the same format.

Can anyone help please??

Thanks

sabitha (BOB member since 2010-02-18)

system · February 13, 2012, 1:04pm

Default date format is MM/DD/YYYY .
Try with giving inputs in MM/DD/YYYY format.

pravin_gaikwad (BOB member since 2010-03-27)

system · February 13, 2012, 1:19pm

Hi,

Thanks for the reply. I am entering 01/01/2012 still i am getting error.

sabitha (BOB member since 2010-02-18)

system · February 13, 2012, 1:39pm

Please try format ‘YYYY-MM-DD hh:mm:ss’ and let me know its working or not…

pravin_gaikwad (BOB member since 2010-03-27)

system · February 14, 2012, 12:07pm

Check the LOVs generated at the universe level…it would be easier for you to check the format.

nitin_gons (BOB member since 2009-05-26)

system · February 23, 2012, 7:43pm

Removed as per this topic.

gigi (BOB member since 2010-03-27)