BI Publisher date Format

Hello,

I want to develop a report for listing MISCELLANEOUS cash Receipts based on Receipt date. I have designed the script as under :

SELECT ACRA.RECEIPT_NUMBER,ACRA.CURRENCY_CODE,

ACRA.RECEIPT_DATE,

ACRA.COMMENTS,

ACRA.AMOUNT

FROM

APPS.AR_CASH_RECEIPTS_ALL ACRA

WHERE

ACRA.TYPE <> 'CASH'

AND

TO_CHAR(ACRA.RECEIPT_DATE,'DD-MON-YYYY') = :P_DATE

ORDER BY ACRA.RECEIPT_NUMBER;

When I execute this in PLSQL, the system prompts to enter the date parameter. I entered as 01/JUL/15 but no data is fetched.

However, if I execute the following query, then the data rows are extracted.

SELECT ACRA.RECEIPT_NUMBER,ACRA.CURRENCY_CODE,