DevOps, CI/CD and Automation

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!

REP-0613 error

user15499Aug 14 2007 — edited Aug 16 2007

I setup two dates in Report Builder with an input mask DD-MON-RRRR. I execute the report and the report retrieves several records. I compile,save and deploy the rdf into a production instance. I setup the executable and request the report. Once the report is complete I received the following errors:
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_Start_Date'.

Report Builder: Release 6.0.8.27.0 - Production on Tue Aug 14 13:45:05 2007

I have changed the input mask in the Report Builder to 'DD-MON-YYYY HR24:MI:SS' and tested but no data is being extracted. The SQL code is as follows on the the date check:
and cst.transaction_costed_date >=:P_START_DATE
and cst.transaction_costed_date <= :P_END_DATE
Would appreciate any help.
Steve