Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01830 :date format picture ends before converting entire input string.

satish kumar94583Apr 23 2009 — edited Apr 27 2009

Hi,

could any body help me to resolve this.. i am getting error
ORA-01830 :date format picture ends before converting entire input string.
I am using Discoverer version 4.1.14.09.00

when i run the work sheet for a month of data for some months it is working fine.... for some months i am getting the above error.

For ex: Discoverer report having two parameters.

1. First Shipping Day '01-APR-2009'
2. Last Shipping Day '23-APR-2009'

The condition for parameter...
-- TRUNC(NVL(Shipment Date,Ordered Date)) >= :First Shipping Day
-- TRUNC(NVL(Shipment Date,Ordered Date)) <= :Last Shipping Day

Please help to resolve this issue.
Thanks in advance.

Satish.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 25 2009

Added on Apr 23 2009

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

11 comments

5,594 views